Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management An Organizational Perspective

Authors: Richard T. Watson

1st Edition

0471305340, 978-0471305347

More Books

Students also viewed these Databases questions