Question: Relational Schema 1 . Student Columns: studentID ( PK ) , name, major, enrollmentDate 2 . Course Columns: courseID ( PK ) , title, credits,
Relational Schema Student Columns: studentID PK name, major, enrollmentDate Course Columns: courseID PK title, credits, professorID FK departmentID FK roomNumber FK Professor Columns: professorID PK name, department Department Columns: departmentID PK name, building Classroom Columns: roomNumber PK building, capacity Enrollment junction table for manytomany relationship between Student and Course Columns: studentID FK courseID FK Use this information to complete the following please:
Examine the Relational Schema that was created during the Phase I of the project.
Step Based on that schema, create a set of tables for an MS Access database. Name the database and its tables appropriately. Make sure to specify primary keys for all tables. Make sure all referential integrity constraints are enforced.
Step Create all the necessary relationships between the tables.
Step Populate the tables with initial data no less than two no more than ten records per table
Step Create at least three queries for this database.
Step Create at least three forms for this database. You can base your forms on tables, queries, or both
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
