Question
Create a Logical Data Model BEFORE starting to create the database. using an entity relationship diagram. You need to determine the names of the fields.
Create a Logical Data Model BEFORE starting to create the database. using an entity relationship diagram. You need to determine the names of the fields. Using entoitys CRN, Subj, Crse, Title, Cr, GrMode, Campus, Days, Time, Bldg, Room, and Instructor. You will be tracking the following data in your database: Instructors names, course names, room number, class time, class day(s), semester start and end dates, credit hours, course prefix, course number, crn (5 digit unique class identifier), Class type face to face or blended. diagram should include the following: 1. Each Entity and its contents. 2. Primary Key (pk) 3. Foreign Keys (fk) 4. Cardinality One-to-One (represented by a solid straight line attached to each entity) One-to-Many (represented by a straight line with a crows foot at the many end) Many-to-Many (represented by a straight line with a crows foot at each end) Crows Foot notation representing On
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started