Question: Tiny College uses a Student Registration System to manage course enrollment, class schedules, and student records. The database structure includes the following tables: COURSE, CLASS,
Tiny College uses a Student Registration System to manage course enrollment, class schedules, and student records. The database structure includes the following tables: COURSE, CLASS, ENROLL, and STUDENT.
Consider this scenario: Sarah, a student at Tiny College, wants to enroll in a new set of classes for the semester. She logs in to the registration system and selects courses based on her department's requirements. Each course has one or more class sections with specific times, rooms, and instructors. For example, Sarah might enroll in a "Database Systems" course, choosing a section taught by Professor Smith on Tuesdays and Thursdays.
Once Sarah selects her classes, the system updates the ENROLL table to reflect her enrollment and assigns her a grade placeholder for each class. The system also maintains her student information, including her program, GPA, and contact details. The Tiny College relational diagram in Figure shows the initial entities and attributes of Tiny College. Figures and details included in photos. I need help with creating an Entity Relationship Diagram using Crows Foot notation for Tiny College using any appropriate tools.
Figure : Relational Diagram of Tiny College
Based on figure answer the following questions using the figure below from Microsoft Access as your guide. b List all attributes for each entity. Identify primary keys and foreign keys.
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
