Assume we implemented the following mini-database CID SECID STYPE Student SID SNAME Std_Enrolls_Sec Course 1030 1 SID CID SECID 1003 Eshaan Barry 1002 1045 2 GRADE 0 CID CNAME Reg 1030 2 Reg 1480 Networking 1045 1 WWW 1000 Chinmaya Mahapatra 1000 1045 1 0 2221 Database Systems 1045 2 WWW 1005 Jack Lei 1002 1045 1 70 1045 Web Programming 1045 3 WWW 1001 Iris Chang 1000 1030 1 95 1050 Intro to Computers 1045 4 WWW 1002 Jocelyn Bowes 1000 1480 3 97 1030 Web Development 1045 5 Reg 1004 Jagmeet Singh 1000 1480 2 75 1280 Linux Systems 1050 1 WWW 1006 Rodrigo Ferrara 1000 1050 1 98 1280 1 WWW 1002 1050 1 90 1280 2 Reg 1002 1280 2 45 1480 1 WWW 1002 1480 3 72 1480 2 WWW 1003 1045 4 65 1480 3 WWW 1003 1480 3 79 1001 1030 1 75 1001 1280 2 40 1000 1045 2 0 1000 1045 3 90 Relational database schema is: Student (SID(PK), SName) 1000 1045 4 90 Course (CID(PK), CName) 1000 1045 5 95 1000 1030 2 95 1000 1480 1 Course_Section ((CID, SecID)(PK), SType) Std_Enrolles_Sec ((SID, CID, SecID)(PK), Grade) 99 1000 1280 1 75 1001 1045 3 75 1000 1280 2 100 Assume we implemented the following mini-database CID SECID STYPE Student SID SNAME Std_Enrolls_Sec Course 1030 1 SID CID SECID 1003 Eshaan Barry 1002 1045 2 GRADE 0 CID CNAME Reg 1030 2 Reg 1480 Networking 1045 1 WWW 1000 Chinmaya Mahapatra 1000 1045 1 0 2221 Database Systems 1045 2 WWW 1005 Jack Lei 1002 1045 1 70 1045 Web Programming 1045 3 WWW 1001 Iris Chang 1000 1030 1 95 1050 Intro to Computers 1045 4 WWW 1002 Jocelyn Bowes 1000 1480 3 97 1030 Web Development 1045 5 Reg 1004 Jagmeet Singh 1000 1480 2 75 1280 Linux Systems 1050 1 WWW 1006 Rodrigo Ferrara 1000 1050 1 98 1280 1 WWW 1002 1050 1 90 1280 2 Reg 1002 1280 2 45 1480 1 WWW 1002 1480 3 72 1480 2 WWW 1003 1045 4 65 1480 3 WWW 1003 1480 3 79 1001 1030 1 75 1001 1280 2 40 1000 1045 2 0 1000 1045 3 90 Relational database schema is: Student (SID(PK), SName) 1000 1045 4 90 Course (CID(PK), CName) 1000 1045 5 95 1000 1030 2 95 1000 1480 1 Course_Section ((CID, SecID)(PK), SType) Std_Enrolles_Sec ((SID, CID, SecID)(PK), Grade) 99 1000 1280 1 75 1001 1045 3 75 1000 1280 2 100
Assume we implemented the following mini-database CID SECID STYPE Student SID SNAME Std_Enrolls_Sec Course 1030 1 SID CID SECID 1003 Eshaan Barry 1002 1045 2 GRADE 0 CID CNAME Reg 1030 2 Reg 1480 Networking 1045 1 WWW 1000 Chinmaya Mahapatra 1000 1045 1 0 2221 Database Systems 1045 2 WWW 1005 Jack Lei 1002 1045 1 70 1045 Web Programming 1045 3 WWW 1001 Iris Chang 1000 1030 1 95 1050 Intro to Computers 1045 4 WWW 1002 Jocelyn Bowes 1000 1480 3 97 1030 Web Development 1045 5 Reg 1004 Jagmeet Singh 1000 1480 2 75 1280 Linux Systems 1050 1 WWW 1006 Rodrigo Ferrara 1000 1050 1 98 1280 1 WWW 1002 1050 1 90 1280 2 Reg 1002 1280 2 45 1480 1 WWW 1002 1480 3 72 1480 2 WWW 1003 1045 4 65 1480 3 WWW 1003 1480 3 79 1001 1030 1 75 1001 1280 2 40 1000 1045 2 0 1000 1045 3 90 Relational database schema is: Student (SID(PK), SName) 1000 1045 4 90 Course (CID(PK), CName) 1000 1045 5 95 1000 1030 2 95 1000 1480 1 Course_Section ((CID, SecID)(PK), SType) Std_Enrolles_Sec ((SID, CID, SecID)(PK), Grade) 99 1000 1280 1 75 1001 1045 3 75 1000 1280 2 100 Assume we implemented the following mini-database CID SECID STYPE Student SID SNAME Std_Enrolls_Sec Course 1030 1 SID CID SECID 1003 Eshaan Barry 1002 1045 2 GRADE 0 CID CNAME Reg 1030 2 Reg 1480 Networking 1045 1 WWW 1000 Chinmaya Mahapatra 1000 1045 1 0 2221 Database Systems 1045 2 WWW 1005 Jack Lei 1002 1045 1 70 1045 Web Programming 1045 3 WWW 1001 Iris Chang 1000 1030 1 95 1050 Intro to Computers 1045 4 WWW 1002 Jocelyn Bowes 1000 1480 3 97 1030 Web Development 1045 5 Reg 1004 Jagmeet Singh 1000 1480 2 75 1280 Linux Systems 1050 1 WWW 1006 Rodrigo Ferrara 1000 1050 1 98 1280 1 WWW 1002 1050 1 90 1280 2 Reg 1002 1280 2 45 1480 1 WWW 1002 1480 3 72 1480 2 WWW 1003 1045 4 65 1480 3 WWW 1003 1480 3 79 1001 1030 1 75 1001 1280 2 40 1000 1045 2 0 1000 1045 3 90 Relational database schema is: Student (SID(PK), SName) 1000 1045 4 90 Course (CID(PK), CName) 1000 1045 5 95 1000 1030 2 95 1000 1480 1 Course_Section ((CID, SecID)(PK), SType) Std_Enrolles_Sec ((SID, CID, SecID)(PK), Grade) 99 1000 1280 1 75 1001 1045 3 75 1000 1280 2 100
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Solve this

Transcribed Image Text:Assume we implemented the following mini-database
CID SECID STYPE
Student
SID
SNAME
Std_Enrolls_Sec
Course
1030 1
SID
CID
SECID
1003 Eshaan Barry
1002 1045 2
GRADE
0
CID
CNAME
Reg
1030 2
Reg
1480 Networking
1045
1
WWW
1000 Chinmaya Mahapatra
1000 1045 1
0
2221
Database Systems
1045
2
WWW
1005 Jack Lei
1002 1045 1
70
1045 Web Programming
1045 3
WWW
1001 Iris Chang
1000 1030 1
95
1050 Intro to Computers
1045 4
WWW
1002 Jocelyn Bowes
1000 1480 3
97
1030 Web Development
1045 5
Reg
1004 Jagmeet Singh
1000 1480 2
75
1280 Linux Systems
1050 1
WWW
1006 Rodrigo Ferrara
1000 1050 1
98
1280
1
WWW
1002
1050 1
90
1280
2
Reg
1002 1280 2
45
1480 1
WWW
1002 1480 3
72
1480
2
WWW
1003 1045 4
65
1480
3
WWW
1003 1480 3
79
1001 1030 1
75
1001 1280 2
40
1000 1045 2
0
1000 1045 3
90
Relational database schema is:
Student (SID(PK), SName)
1000 1045 4
90
Course (CID(PK), CName)
1000 1045 5
95
1000 1030 2
95
1000 1480 1
Course_Section ((CID, SecID)(PK), SType)
Std_Enrolles_Sec ((SID, CID, SecID)(PK), Grade)
99
1000 1280 1
75
1001 1045 3
75
1000 1280 2
100

Transcribed Image Text:Assume we implemented the following mini-database
CID SECID STYPE
Student
SID
SNAME
Std_Enrolls_Sec
Course
1030 1
SID
CID
SECID
1003 Eshaan Barry
1002 1045 2
GRADE
0
CID
CNAME
Reg
1030 2
Reg
1480 Networking
1045
1
WWW
1000 Chinmaya Mahapatra
1000 1045 1
0
2221
Database Systems
1045
2
WWW
1005 Jack Lei
1002 1045 1
70
1045 Web Programming
1045 3
WWW
1001 Iris Chang
1000 1030 1
95
1050 Intro to Computers
1045 4
WWW
1002 Jocelyn Bowes
1000 1480 3
97
1030 Web Development
1045 5
Reg
1004 Jagmeet Singh
1000 1480 2
75
1280 Linux Systems
1050 1
WWW
1006 Rodrigo Ferrara
1000 1050 1
98
1280
1
WWW
1002
1050 1
90
1280
2
Reg
1002 1280 2
45
1480 1
WWW
1002 1480 3
72
1480
2
WWW
1003 1045 4
65
1480
3
WWW
1003 1480 3
79
1001 1030 1
75
1001 1280 2
40
1000 1045 2
0
1000 1045 3
90
Relational database schema is:
Student (SID(PK), SName)
1000 1045 4
90
Course (CID(PK), CName)
1000 1045 5
95
1000 1030 2
95
1000 1480 1
Course_Section ((CID, SecID)(PK), SType)
Std_Enrolles_Sec ((SID, CID, SecID)(PK), Grade)
99
1000 1280 1
75
1001 1045 3
75
1000 1280 2
100
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

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY