Computers and Technology, 27.03.2021 02:30 tiffanybrown703

You have been asked to design a database for the university administration, which records the following information: 1. All students necessarily have a unique student ID, a name, and a university email address. Each student is also either an undergraduate or a graduate student.
2. Each graduate student has an advisor.
3. Each undergraduate student has a major.
4. Students take courses. A student may take one course, multiple courses, or no courses.
5. Each course has a course number, course name, and days of the week the course is scheduled.
6. Each course has exactly one head TA, who is a graduate student.
Draw an ER diagram for this application. Decide the key attributes and identify them on the diagram. Be sure to indicate all key constraints. Please state all assumptions you make in your answers.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 22:00, delawdermia27

Researchers measured the data speeds for a particular smartphone carrier at 50 airports. the highest speed measured was 78.1 mbps. the complete list of 50 data speeds has a mean of x overbarequals16.11 mbps and a standard deviation of sequals18.65 mbps. a. what is the difference between carrier's highest data speed and the mean of all 50 data speeds? b. how many standard deviations is that [the difference found in part (a)]? c. convert the carrier's highest data speed to a z score. d. if we consider data speeds that convert to z scores between minus2 and 2 to be neither significantly low nor significantly high, is the carrier's highest data speed significant? a. the difference is nothing mbps.

Answers: 3

continue

Computers and Technology, 22.06.2019 23:50, Crull5999

List a few alternative options and input and output over the standerd keyboard and monitor. explain their functioning in details.

Answers: 2

continue

Computers and Technology, 23.06.2019 10:00, austintules2005

Whats three fourths of 15(this is supposed to be in math but i clicked too fast)

Answers: 1

continue

Computers and Technology, 24.06.2019 02:30, journeyhile5

How to apply the fly in effect to objects on a slide