The university would like to set up a relational database corresponding to this form. a. Normalize the database into INF including only one table. Give the content of the table as well as the list of functional dependencies for the table. b. Normalize the database into 2NF. Give the content of each table after as well as the list of functional dependencies for each table after normalizing. c. Normalize the database into 3NF. Give the content of each table after as well as the list of functional dependencies for each table after normalizing.

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...
icon
Related questions
Question

help me with database sql exercise

 

The university would like to set up a relational database corresponding to this form.
a. Normalize the database into INF including only one table. Give the content of the table as well
as the list of functional dependencies for the table.
b. Normalize the database into 2NF. Give the content of each table after as well as the list of
functional dependencies for each table after normalizing.
c. Normalize the database into 3NF. Give the content of each table after as well as the list of
functional dependencies for each table after normalizing.
Transcribed Image Text:The university would like to set up a relational database corresponding to this form. a. Normalize the database into INF including only one table. Give the content of the table as well as the list of functional dependencies for the table. b. Normalize the database into 2NF. Give the content of each table after as well as the list of functional dependencies for each table after normalizing. c. Normalize the database into 3NF. Give the content of each table after as well as the list of functional dependencies for each table after normalizing.
Exercise 2: Having the following form to input the results of students:
Name Birthdate Class Department
CourseID
Roll#
HE130257 Nguyen 2000-05-28 SE1311 SE
Thi
Binh
HE130257 Nguyen 2000-05-28 SE1311 SE
Thi
Binh
HE130257 Nguyen 2000-05-28 SE1311 SE
Thi
Binh
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130246 Nguyen 2000-09-13 SE1311 SE
Minh
Chien
HE130258 Nguyen 2000-08-14 IA1301 IA
Binh
Minh
HE130258 Nguyen 2000-08-14 IA1301 IA
Binh
Minh
HE130258 Nguyen 2000-08-14 IA1301 IA
Binh
Minh
HE130258 Nguyen 2000-08-14 IA1301 IA
Binh
Minh
DB1202
DB1202
DB1202
DB1202
DB1202
DB1202
CSI101
CSI101
CSI101
CSI101
CSI101
CSI101
CSI101
CSI101
CourseName Credits
Introduction to 3
Database
Introduction to 3
Database
Introduction to
Database
Introduction to
Database
3
3
Introduction to 3
Database
Introduction to 3
Database
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Connecting to 3
Computer
Sciences
Results
Exercise#
1
3
1
2
3
4
% Note
20
40
40
20
40
40
15
20
30
35
15
20
30
35
Note
6
5
8
4
m
5
2
4
3
6
4
6
4
Transcribed Image Text:Exercise 2: Having the following form to input the results of students: Name Birthdate Class Department CourseID Roll# HE130257 Nguyen 2000-05-28 SE1311 SE Thi Binh HE130257 Nguyen 2000-05-28 SE1311 SE Thi Binh HE130257 Nguyen 2000-05-28 SE1311 SE Thi Binh HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130246 Nguyen 2000-09-13 SE1311 SE Minh Chien HE130258 Nguyen 2000-08-14 IA1301 IA Binh Minh HE130258 Nguyen 2000-08-14 IA1301 IA Binh Minh HE130258 Nguyen 2000-08-14 IA1301 IA Binh Minh HE130258 Nguyen 2000-08-14 IA1301 IA Binh Minh DB1202 DB1202 DB1202 DB1202 DB1202 DB1202 CSI101 CSI101 CSI101 CSI101 CSI101 CSI101 CSI101 CSI101 CourseName Credits Introduction to 3 Database Introduction to 3 Database Introduction to Database Introduction to Database 3 3 Introduction to 3 Database Introduction to 3 Database Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Connecting to 3 Computer Sciences Results Exercise# 1 3 1 2 3 4 % Note 20 40 40 20 40 40 15 20 30 35 15 20 30 35 Note 6 5 8 4 m 5 2 4 3 6 4 6 4
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY