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
Get step-by-step solutions from verified subject matter experts
