subject

Consider the following database schema: STUDENTS (SNUM: integer, SNAME : string, MAJOR : string, LEVEL : string, AGE : integer)
CLASS (NAME : string, MEETS_AT : time, ROOM : string, FID : integer)
ENROLLED (SNUM : integer, CNAME : string)
FACULTY (FID : integer, FNAME : string, DEPTID : integer)
The meaning of these relations is straightforward; for example, ENROLLED has one record per student-class pair such that the student is enrolled in the class. Express each of the following integrity constraints in SQL unless it is implied by the primary and foreign key constraint; if the constraint cannot be expressed in SQL, say so.
1. No faculty member from department number 5 can teach more than four courses.
2. The number of CS majors must be more than the number of math majors.
3. No student should enroll in more than 2 classes offered by the same faculty.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 24.06.2019 08:30
Formatting rows and columns is similar to cell formatting. in an openoffice calc spreadsheet, you can format data entered into rows and columns with the of the rows and columns options. you can insert rows and columns into, or delete rows and columns from, a spreadsheet. use the insert or delete rows and columns option on the insert tab. alternatively, select the row or column where you want new rows or columns to appear, right-click, and select insert only row or only column options. you can hide or show rows and columns in a spreadsheet. use the hide or show option on the format tab. for example, to hide a row, first select the row, then choose the insert tab, then select the row option, and then select hide. alternatively, you can select the row or columns, right-click, and select the hide or show option. you can adjust the height of rows and width of columns. select row and then select the height option on the format tab. similarly, select column, then select the width option on the format tab. alternatively, you can hold the mouse on the row and column divider, and drag the double arrow to the position. you can also use the autofit option on the table tab to resize rows and columns.
Answers: 1
question
Computers and Technology, 24.06.2019 13:00
Why should you evaluate trends when thinking about a career path?
Answers: 1
question
Computers and Technology, 25.06.2019 19:30
Which animation effects allow text or images to show movement on a slide? check all that apply. - enterance - emphasis - exit - motion paths - add-in - insert
Answers: 1
question
Computers and Technology, 26.06.2019 04:40
What exactly does the value recorded in a single dimension of a sift keypoint descriptor signify?
Answers: 3
You know the right answer?
Consider the following database schema: STUDENTS (SNUM: integer, SNAME : string, MAJOR : string, L...
Questions
question
Physics, 19.05.2020 16:00
question
Mathematics, 19.05.2020 16:00
question
Mathematics, 19.05.2020 16:01
Questions on the website: 13722363