STUD NO STUD_NAME STUD_PHONE STUD STATE STUD_COUNT STUD AG RY E 1 RAM India 20 9716271721 Haryana 9898291281 Punjab 2 RAM India 19 3 SUJIT 7898291981 Rajsthan India 18 4 SURESH Punjab India 21 Table 1 STUDENT COURSE STUD NO COURSE NO 1 COURSE NAME DBMS CI 2 C2 Computer Networks Computer Networks 1 C2 Table 1 Identify the keys and fill it in the following tables:

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
Question

Fast help please ..I'll provide 8 upvotes guaranteed 

STUDENT
STUD_PHONE STUD_STATE
9716271721 Haryana
Punjab
9898291281
7898291981 Rajsthan
Punjab
Table 1
STUDENT COURSE
STUD NO
COURSE NO
1
C1
2
C2
1
C2
Table 2
Identify the keys and fill it in the following tables:
Student:
Key
Super key
Candidate Key
Primary Key
Alternate Key
Foreign key
Student Course:
Key
Super key
Candidate Key
Primary Key
Alternate Key
Foreign key
STUD NO STUD_NAME
1
RAM
2
RAM
3
SUJIT
4
SURESH
STUD_COUNT STUD_AG
RY
India
E
20
India
19
India
18
India
21
COURSE NAME
DBMS
Computer Networks
Computer Networks
Transcribed Image Text:STUDENT STUD_PHONE STUD_STATE 9716271721 Haryana Punjab 9898291281 7898291981 Rajsthan Punjab Table 1 STUDENT COURSE STUD NO COURSE NO 1 C1 2 C2 1 C2 Table 2 Identify the keys and fill it in the following tables: Student: Key Super key Candidate Key Primary Key Alternate Key Foreign key Student Course: Key Super key Candidate Key Primary Key Alternate Key Foreign key STUD NO STUD_NAME 1 RAM 2 RAM 3 SUJIT 4 SURESH STUD_COUNT STUD_AG RY India E 20 India 19 India 18 India 21 COURSE NAME DBMS Computer Networks Computer Networks
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Fundamentals of Boolean Algebra and Digital Logics
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
  • SEE MORE 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