Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve it correct or dont anwer please show the cardinality as n to m like this Draw an Entity relationship diagram (ER) for a university

solve it correct or dont anwer please
show the cardinality as n to m like this
image text in transcribed
Draw an Entity relationship diagram (ER) for a university according to the following rules: 1 - For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. 1 - The student id is identical for each student. ! -- Each course has a number, name and credit. The course number is unique for each course. +-- Each department has a name, code and location. The code is unique for each department. $ - Each course may has one or more sections where each section is belong to only one course. - A department offers one or many courses. 7- Some courses have perquisite courses. 8- Each student could register in one or more courses. In your diagram you need to show the following: 1- The primary key for each entity. 2- The cardinality and participation between entities

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

Computer Accounting With QuickBooks Online

Authors: Donna Kay

2nd Edition

1260888061, 9781260888065

More Books

Students also viewed these Accounting questions

Question

Discuss the importance of linking pay to ethical behavior.

Answered: 1 week ago

Question

Explain how to reward individual and team performance.

Answered: 1 week ago