Design and Build a data base server the following scenario.
Scenario-
Develop a database to house College student and schedule information. The data model should contain the following minimum data structures:
|
Student demographic
|
Student contact
|
|
Student status
|
Courses Catalog (name, section number, time od day, term.
|
|
Courses student is enrolled in
|
Courses student has previously taken
|
|
Course max occupancy
|
Course available occupancy
|
Expectations
Your database design should meet the following minimum reguiremen.
• Design a database - normalizing your database design.
• Construct stored procedures to manage enrollments of a student into courses.
• Demonstrate the use of triggers (ensure course are not over enrolled)
• Develop one (or more) views .r viewing student information and course enrollments (current and previous) by denormal.ing your table data into an easily readable structure
Delivery of Final Project-
• Perform a full backup of Ihe database
• Provide a JPEG/PNG screenshot of the database diagram for your database
• Document (in writing) your stored procedures and how to call them
• Document the triggers implemented in your database (table name, trigger action, what does it do)