Modify the E-R diagram for the Student Registration System to include information about the student majors and the majors allowed in courses. A student can have several majors (which are codes of the various programs in the university, such as CSE, ISE, MUS, ECO). A course can also have several admissible majors, or the list of admissible majors can be empty. In the latter case, anyone is admitted into the course. Express the constraint that says that a course with restrictions on majors can have only those students who hold one of the allowed majors. Alas, in full generality this constraint can be expressed only as an SQL assertion that uses features (which we have yet to study). However, it is possible to express this constraint under the following simplifying assumption: when a student

What will be an ideal response?


The Student entity type gets a newset-valued attribute Major, and similarly for Courses. Under the simplifying assumption mentioned above, the relations Student, Courses, and Transcript each gets a new attribute, Major. The constrain then can be expressed as a foreign-key constraint on the Transcript relation:

```
FOREIGN KEY (StudId, Major)
REFERENCES Student(Id, Major)
```

Computer Science & Information Technology

You might also like to view...

____ solves the ACK storm issue and facilitates TCP session hijacking.?

A. ?SSL B. ?Storm watching C. ?Packet blocking D. ?Encryption

Computer Science & Information Technology

In the default paragraph spacing style, the paragraph spacing is ________

A) 0 pt before and 0 pt after B) 0 pt before and 10 pt after C) 10 pt before and 0 pt after D) 5 pt before and 5 pt after

Computer Science & Information Technology

An informational, authoritative report on a topic of interest to a particular group is called a white paper.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

?Consider the Hub in Microsoft Edge as __________. 

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology