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 15:30
What is a costume plot? why is it important to a film or theater production?
Answers: 2
question
Computers and Technology, 23.06.2019 09:00
The first screen you see when you open word2016 what is called?
Answers: 1
question
Computers and Technology, 23.06.2019 15:20
An ou structure in your domain has one ou per department, and all the computer and user accounts are in their respective ous. you have configured several gpos defining computer and user policies and linked the gpos to the domain. a group of managers in the marketing department need different policies that differ from those of the rest of the marketing department users and computers, but you don't want to change the top-level ou structure. which of the following gpo processing features are you most likely to use? a, block inheritance b, gpo enforcement c, wmi filtering d, loopback processing
Answers: 3
question
Computers and Technology, 23.06.2019 18:30
Write a program that prints the day number of the year, given the date in the form month-day-year. for example, if the input is 1-1-2006, the day number is 1; if the input is 12-25-2006, the day number is 359. the program should check for a leap year. a year is a leap year if it is divisible by 4, but not divisible by 100. for example, 1992 and 2008 are divisible by 4, but not by 100. a year that is divisible by 100 is a leap year if it is also divisible by 400. for example, 1600 and 2000 are divisible by 400. however, 1800 is not a leap year because 1800 is not divisible by 400.
Answers: 3
You know the right answer?
Draw an Entity relationship diagram (ER) for a university according to the following rules: 1- ­‐...
Questions
question
Mathematics, 29.08.2019 05:20
question
Mathematics, 29.08.2019 05:20
question
Mathematics, 29.08.2019 05:20
Questions on the website: 13722361