Question: Relational Schema 1 . Student Columns: studentID ( PK ) , name, major, enrollmentDate 2 . Course Columns: courseID ( PK ) , title, credits,

Relational Schema 1. Student Columns: studentID (PK), name, major, enrollmentDate 2. Course Columns: courseID (PK), title, credits, professorID (FK), departmentID (FK), roomNumber (FK)3. Professor Columns: professorID (PK), name, department 4. Department Columns: departmentID (PK), name, building 5. Classroom Columns: roomNumber (PK), building, capacity 6. Enrollment (junction table for many-to-many 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 1. 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 2. Create all the necessary relationships between the tables.
Step 3. Populate the tables with initial data (no less than two no more than ten records per table).
Step 4. Create at least three queries for this database.
Step 5. Create at least three forms for this database. (You can base your forms on tables, queries, or both).
Relational Schema 1 . Student Columns: studentID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!