subject

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.
2- ­‐ The student id is identical for each student.
3- ­‐ Each course has a number, name and credit. The course number is unique for each course.
4- ­‐ Each department has a name, code and location. The code is unique for each department.
5- ­‐ Each course may has one or more sections where each section is belong to only one course.
6- ­‐ 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.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 20:00
What is used to analyze and summarize your data without graphical support
Answers: 1
question
Computers and Technology, 23.06.2019 01:30
Which tab is used to change the theme of a photo album slide show? a. design b. view c. transitions d. home
Answers: 1
question
Computers and Technology, 25.06.2019 02:00
Lisa is making a presentation for her project and she wants to use the logo of her company in her presentation. which element would she use to make her logo stand out in her presentation? a. gradation b. contrast c. alignment d. balance
Answers: 1
question
Computers and Technology, 25.06.2019 07:20
Acompany's intranet is set up on this type of server. application communication print web
Answers: 1
You know the right answer?
Draw an Entity relationship diagram (ER) for a university according to the following rules: 1- ­‐...
Questions
question
History, 07.04.2021 07:00
question
Mathematics, 07.04.2021 07:00
question
Biology, 07.04.2021 07:00
question
Spanish, 07.04.2021 07:00
Questions on the website: 13722367