Based on the information provided, indicate for each of the following sets of attributes whether it is a key for Articles or NOT.  1. {NUMBER} 2. {NUMBER, TECHNICAL_REPORT_ID} 3. {TITLE} 4. {TITLE, YEAR} 5. {STARTPAGE, PUBLICATION, VOLUME} 6. {NUMBER, TITLE, TECHNICAL_REPORT_ID}

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

Based on the information provided, indicate for each of the following sets of attributes
whether it is a key for Articles or NOT. 
1. {NUMBER}
2. {NUMBER, TECHNICAL_REPORT_ID}
3. {TITLE}
4. {TITLE, YEAR}
5. {STARTPAGE, PUBLICATION, VOLUME}
6. {NUMBER, TITLE, TECHNICAL_REPORT_ID}

Consider the following relation:
ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE,
TECHNICAL_REPORT_ID)
The relation contains information on articles published in publications (Journals). Each article
has a unique number, title, and information on where to find it (name of the publication, what
volume, and on which pages is appearing), also the ID of the technical report is specified.
The following is an illustration of the relation:
NUMBER
TITLE
PUBLICATION| VOLUME
YEAR
STARTPAGE ENDPAGE
TECHNICAL_REPORT_ID
240
Junior PC games
SAJS
15
2019
141
153
87
330
Early Childwood
SAJS
14
2016
79
95
26
330
Early Childwood
SAJS
14
2016
79
95
65
930
Data Dictionary
SAJEMS
13
2016
211
233
74
750
SACJ
P_value vs
Equilibriam
15
2020
1.
4
99
solved
770
Data missed
SAJEMS
15
2020
1.
6.
89
870
Data missed
Nature
3333
2020
33
33
89
Transcribed Image Text:Consider the following relation: ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE, TECHNICAL_REPORT_ID) The relation contains information on articles published in publications (Journals). Each article has a unique number, title, and information on where to find it (name of the publication, what volume, and on which pages is appearing), also the ID of the technical report is specified. The following is an illustration of the relation: NUMBER TITLE PUBLICATION| VOLUME YEAR STARTPAGE ENDPAGE TECHNICAL_REPORT_ID 240 Junior PC games SAJS 15 2019 141 153 87 330 Early Childwood SAJS 14 2016 79 95 26 330 Early Childwood SAJS 14 2016 79 95 65 930 Data Dictionary SAJEMS 13 2016 211 233 74 750 SACJ P_value vs Equilibriam 15 2020 1. 4 99 solved 770 Data missed SAJEMS 15 2020 1. 6. 89 870 Data missed Nature 3333 2020 33 33 89
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education