2023 Answer all questions with reference to the STUDENT COURSE and GRADE tables presented below | Assignment Collections
Computer Science 2023 MMIS 630: Database Systems
2023 Answer all questions with reference to the STUDENT COURSE and GRADE tables presented below | Assignment Collections
Answer all questions with reference to the STUDENT, COURSE, and GRADE tables presented below for which the primary keys, foreign keys, and referential integrity constraints are specified.
STUDENT
Primary Key: STUDENT_ID
|
STUDENT_ID |
STUDENT_LNAME |
STUDENT_FNAME |
MAJOR |
|
150-70-5879 |
Jones |
Ray |
CS |
|
276-32-4380 |
Brown |
John |
MA |
|
280-90-8766 |
Lee |
Mae |
CS |
|
327-50-9090 |
Green |
Bruce |
CS |
|
370-80-5050 |
Cooper |
Bill |
MA |
|
430-76-6858 |
Woo |
Dan |
EE |
|
430-80-9262 |
Bose |
Sameer |
EE |
|
526-77-3568 |
Ryan |
Pat |
CS |
|
527-90-5470 |
McGraw |
Julia |
CS |
|
660-80-5497 |
Gonzales |
Jose |
CS |
|
720-60-5000 |
Parker |
Nancy |
CS |
|
824-58-5473 |
Smith |
John |
MA |
|
900-90-9000 |
Bush |
Bill |
EE |
|
925-05-6872 |
Liu |
Tsui |
EE |
|
967-54-7112 |
Wang |
John |
MA |
COURSE
Primary Key: COURSE_NO
|
COURSE_NO |
COURSE_NAME |
DEPT_CODE |
CREDITS |
|
CS100 |
Data Structures |
CS |
3 |
|
CS120 |
Algorithms |
CS |
3 |
|
CS200 |
Object Oriented Programming |
CS |
4 |
|
CS220 |
Database Management |
CS |
4 |
|
CS240 |
Data Communications |
CS |
4 |
|
CS300 |
Distributed Systems |
CS |
4 |
|
EE100 |
Circuit Analysis |
EE |
3 |
|
EE120 |
Communication Theory |
EE |
3 |
|
EE200 |
VLSI Design |
EE |
4 |
|
EE300 |
Packet Switching Networks |
EE |
4 |
|
MA100 |
Calculus |
MA |
3 |
|
MA200 |
Advanced Calculus |
MA |
4 |
|
MA220 |
Discrete Mathematics |
MA |
4 |
|
MA300 |
Number Theory |
MA |
4 |
GRADE
Primary Key: COURSE_NO + STUDENT_ID
Foreign Keys: COURSE_NO references COURSE , RESTRICT on DELETE
STUDENT_ID references STUDENT , CASCADE on DELETE
|
COURSE_NO |
STUDENT_ID |
GRADE |
|
CS100 |
150-70-5879 |
B |
|
EE100 |
150-70-5879 |
B |
|
EE100 |
276-32-4380 |
C |
|
CS100 |
280-90-8766 |
A |
|
EE100 |
280-90-8766 |
A |
|
CS100 |
327-50-9090 |
B |
|
CS100 |
430-76-6858 |
A |
|
EE100 |
430-76-6858 |
B |
|
MA220 |
660-80-5497 |
B |
|
CS200 |
720-60-5000 |
B |
|
CS200 |
824-58-5473 |
C |
|
MA220 |
824-58-5473 |
B |
|
EE200 |
824-58-5473 |
B |
|
MA220 |
900-90-9000 |
B |
|
CS200 |
925-05-6872 |
A |
|
EE200 |
925-05-6872 |
A |
|
CS200 |
967-54-7112 |
A |
|
EE200 |
967-54-7112 |
B |
- Explain what happens when you try to delete the following records from the COURSE table:
(a)
|
COURSE_NO |
COURSE_NAME |
DEPT_CODE |
CREDITS |
|
CS120 |
Algorithms |
CS |
3 |
(b)
|
COURSE_NO |
COURSE_NAME |
DEPT_CODE |
CREDITS |
|
CS100 |
Data Structures |
CS |
3 |
2. Specify whether the following records can be added to the GRADE table.
Justify your answer in each case:
(a)
|
COURSE_NO |
STUDENT_ID |
GRADE |
|
CS220 |
900-90-9000
|
B |
(b)
|
COURSE_NO |
STUDENT_ID |
GRADE |
|
CS100 |
|
B |
(c)
|
COURSE_NO |
STUDENT_ID |
GRADE |
|
CS100 |
980-70-5879 |
B |
(d)
|
COURSE_NO |
STUDENT_ID |
GRADE |
|
MA220 |
967-54-7112 |
B |
- Explain what happens when you try to delete the following records from the STUDENT table:
(a)
|
STUDENT_ID |
STUDENT_LNAME |
STUDENT_FNAME |
MAJOR |
|
150-70-5879 |
Jones |
Ray |
CS
|
(b)
|
STUDENT_ID |
STUDENT_LNAME |
STUDENT_FNAME |
MAJOR |
|
280-90-8766 |
Lee |
Mae |
CS |
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.
Place Order Now
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper
#Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational
