4:04 l LTE 4:04 LTE DB Quiz No.5 (12:30@OUJI aelga) DB Quiz No.5 (12:30@ULJI alg) CREATE TABLE Institution (name VARCHAR(50), country VARCHAR(50).year INT, CREATE TABLE HighDegree (professoriD INT REFERENCES Professor(ID).projectiD INT REFERENCES Project(ID),schoolName VARCHAR(50).institutionName VARCHAR(50).FOREIGN KEY O Number PRIMARY KEY (name, country): O Name and Num WA The following is an instance of the relation: CREATE TABLE Author (researcherID INT REFERENCES Researcher(ID).paperID INT REFERENCES Paper(ID).PRIMARY KEY (researcheriD, paperiD); O Name (schoolName,institutionName) REFERENCES School(name.insitutionName), PRIMARY KEY (professorID, studentID, schoolName, institutionName): Based on the above, indicate for each of the following sets of attributes whether it is a key for Articles Table? CREATE TABLE Partof (professorID INT REFERENCES Professor(ID), studentID INT REFERENCES Researcher(ID),PRIMARY KEY (professorID, projectiD)): Indicate which one of the following Table HighDegree has: * expressions is NOT valid SQL statement? Toraal n tatpage C eing 2004 The relationship between Deterniasetse setoare BLeinari a le e ae a 2e0s L 13 Pe P renirad a e Bi Table Institution and Table Author is O 4 PRIMARY KEYS 200 4200 Ketare 221 2000 JAO 2 12 at Qidel aid on O 2 FOREIGN KEYS O SELECT SUM(") FROM Articles, O startpage journal,issue O m:1 2 FOREIGN KEYS and 4 PRIMARY SELECT FROM Articles WHERE KEYS O title endpage-startpage>10; O 1:1 2 FOREIGN KEYS and 2 PRIMARY KEYS O SELECT AVG(year) FROM Articles WHERE title LIKE 'C%"; title. year O 1:m O ID, TR-ID O m:n SELECT COUNT(") FROM Articles GROUP BY year; O ID,title, TR-ID WA ID Each person has an ID number, and the ID number is unique to one person.
4:04 l LTE 4:04 LTE DB Quiz No.5 (12:30@OUJI aelga) DB Quiz No.5 (12:30@ULJI alg) CREATE TABLE Institution (name VARCHAR(50), country VARCHAR(50).year INT, CREATE TABLE HighDegree (professoriD INT REFERENCES Professor(ID).projectiD INT REFERENCES Project(ID),schoolName VARCHAR(50).institutionName VARCHAR(50).FOREIGN KEY O Number PRIMARY KEY (name, country): O Name and Num WA The following is an instance of the relation: CREATE TABLE Author (researcherID INT REFERENCES Researcher(ID).paperID INT REFERENCES Paper(ID).PRIMARY KEY (researcheriD, paperiD); O Name (schoolName,institutionName) REFERENCES School(name.insitutionName), PRIMARY KEY (professorID, studentID, schoolName, institutionName): Based on the above, indicate for each of the following sets of attributes whether it is a key for Articles Table? CREATE TABLE Partof (professorID INT REFERENCES Professor(ID), studentID INT REFERENCES Researcher(ID),PRIMARY KEY (professorID, projectiD)): Indicate which one of the following Table HighDegree has: * expressions is NOT valid SQL statement? Toraal n tatpage C eing 2004 The relationship between Deterniasetse setoare BLeinari a le e ae a 2e0s L 13 Pe P renirad a e Bi Table Institution and Table Author is O 4 PRIMARY KEYS 200 4200 Ketare 221 2000 JAO 2 12 at Qidel aid on O 2 FOREIGN KEYS O SELECT SUM(") FROM Articles, O startpage journal,issue O m:1 2 FOREIGN KEYS and 4 PRIMARY SELECT FROM Articles WHERE KEYS O title endpage-startpage>10; O 1:1 2 FOREIGN KEYS and 2 PRIMARY KEYS O SELECT AVG(year) FROM Articles WHERE title LIKE 'C%"; title. year O 1:m O ID, TR-ID O m:n SELECT COUNT(") FROM Articles GROUP BY year; O ID,title, TR-ID WA ID Each person has an ID number, and the ID number is unique to one person.
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
Related questions
Question
Transcribed Image Text:4:04
l LTE
4:04
i LTE
DB Quiz No.5 (12:30@ULJI selga)
DB Quiz No.5 (12:30@ouI selga)
CREATE TABLE Institution (name
VARCHAR(50),country VARCHAR(50).year
CREATE TABLE HighDegree
(professorID INT REFERENCES
Professor(ID).projectID INT REFERENCES
Project(ID),schoolName
VARCHAR(50),institutionName
VARCHAR(50), FOREIGN KEY
(schoolName,institutionName)
REFERENCES
School(name.,insitutionName), PRIMARY
KEY (professorID, studentID, schoolName,
institutionName);
O Number
INT,
(name, country):
PRIMARY KEY
O
Name and Num
WA
The following is an instance of the relation:
CREATE TABLE Author (researcherlD INT
REFERENCES Researcher(ID),.paperID INT
REFERENCES Paper(ID).PRIMARY KEY
(researcherlD, paperID));
O Name
Based on the above, indicate for each of the
following sets of attributes whether it is a
key for Articles Table?
CREATE TABLE PartOf (professorID INT
REFERENCES Professor(ID), studentID INT
REFERENCES Researcher(ID),PRIMARY
KEY (professorID, projectID);
Indicate which one of the following
expressions is NOT valid SQL statement?
Table HighDegree has: *
ouraal iuyear atatya age Th ID
121
ID
itle
Cachee leshiE
aa Dataiaiatse Dicttonaries Al
3 Deternisiatse bictsonartes
a Diesionariea ia lean apace anco
Pre P rencirod
42
The relationship between
Table Institution and Table Author is
JA
41 200s
21
200s
2000
200
47
O 4 PRIMARY KEYS
JACH
77
What sdel mied
Nature 2a 20os
ar Osdel uiaed
22
O 2 FOREIGN KEYS
O SELECT SUM(") FROM Articles;
O
startpage.journal, issue
O m:1
SELECT FROM Articles WHERE
endpage-startpage>10;
2 FOREIGN KEYS and 4 PRIMARY
1
KEYS
O title
O 1:1
2 FOREIGN KEYS and 2 PRIMARY
O KEYS
SELECT AVG(year) FROM Articles
O WHERE title LIKE 'C%";
O title, year
O 1:m
ID,TR-ID
O m:n
SELECT COUNT(") FROM Articles
GROUP BY year:
O ID,title, TR-ID
WA
ID
Each person has an ID number, and the lID
number is unique to one person.
O O O O O
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage