Instance of the College Database ACC Accounting CIS Computer Information Systems
ID: 3732838 • Letter: I
Question
Instance of the College Database ACC Accounting CIS Computer Information Systems Fiterman (212) 220-8385 MAT Mathematics NUR Nursing Fiterman (212) 220-8190 Main (212) 220-1335 Main (212) 220-8230 Department names are unique. Departments have distinct phone numbers. - Course courseNo deptio ACC122 ACC Acc ACC241 ACC Federal Taxation CIS395 CE credits capacity Principles 3 32 30 26 26 30 24 18 CIS Database Systems cis (UNIX MAT20 MAT Statistics MAT315 MAT Algebra NUR411NUR Surgical Nursing Student firstName lastName dateOfBirth GPA deptiD N012 Roxane Campain 12-MAR-1995 roxane@hotmail com 3.51 NUR C033 Noah MO91 Maicolm Tromblay 1 A117 Teddy Pedrozo 16-NOV-1998 tpedrozoegmail.com 3.69 ACC A125 Samira Heintzman 08-JAN-1999 heintz@gmail.com 3.74 M148 Irina Kalafatis23-JUN-1993 nkalafatis@aol.com 236 cis 9-SEP-1991 tromblay@coxnet 3.88 MAT ACC Garda 02-APR-1997 igarcia @juno.com 335 MAT - Students with the same names do not have the same date of birth courseNo semester grade Fall 2016 CO33 5395 | CO33 CIS395Fall 2017 A125 ACC241 Fall 2016 M091 MAT209Fall 2017 A117 MAT315 Sprine 2017 C M148 MAT209Fall 2017A M091 MATS 15 Spring 201 A N012 NUR411 Fall 2016 A117 MAT209 Spring 2017 D M148 MAT315 Fall 2016Explanation / Answer
answer 14. Foreign key is one that is the primary key of other table.
studentId - from Student table.
courseNo- from Course table.
answer 15. Primary key is can be a single attribute or more than one attribute that can uniquely identify a row.
In the Enrollment table, the primary key is more than one attribute.
The primary key is (studentId,courseNo,semester)
answer 1. The syntax is SELECT column_name FROM table_name;
so , the anwer is
SELECT name FROM Department;
answer 2. The syntax is- SELECT * FROM table_name WHERE condition;
SELECT * FROM Student WHERE GPA>3.5;
answer 3.The syntax is -SELECT * FROM table_name WHERE condition;
SELECT deptId,title FROM Course WHERE credits=3;