MIS 421 - Business Database Development
Fall 2024
Sister Cities Association (SCA) Database Project
Web site is still under development and subject to change throughout the quarter.
Home
Faculty Pages
Dr. Xiaofeng Chen
Prof. Michela Meucci
Teamwork
Peer Programming
Communication & Coordination
Team Roster
Team WorkRecord Template
SCA Reference Documents
Design/Implemenation Cycle
421 Data Specifications
Diagramming Guidelines
Naming Conventions
How To ...
Set up certain SSMS options
Create Identity PKs
Create Other Features
Create Views
Backup a Table
Create an FK relationship
Create SQL Server Databases
Create a SQL Server ERD
Import: integers & large strings (Cities)
Import: strings resembling #s (People)
Import: use the standalone import & export wizard
Import: finalizing imported tables
SCA Labs
SCA Submission Instructions
Lab 1 Design
Lab 2 Design
Required Naming Conventions
Lab 2 Implementation
Lab 3 Design
Lab 3a Implementation
Lab 3b Implementation
Lab 4 Design
Lab 4 Implementation
Lab 5 Design
Lab 5 Implementation
Lab 6 Design
Lab 6 Implementation
Lab 7 Design (none)
Lab 7 Implementation
Lab Midterm Exam Study Guide
Lab Final Study Guide
Textbook Web References
Helpful MIS References