Database Systems: Functional Dependencies and Normalization

The assignment requires students to analyze the given data and identify functional dependencies, decompose a relation into 3NF, and design a relational schema. It also involves identifying referential integrity constraints and creating an ER diagram with a 3NF relation.

Running head: DATABASE SYSTEMS
Database Systems
Name of the Student
Name of the University
Author’s Note

1
DATABASE SYSTEMS
Table of Contents
Data Given.......................................................................................................................................2
Dependency Diagram......................................................................................................................2
Functional Dependencies.................................................................................................................3
Decomposition of the relation into a set of 3 NF.............................................................................3
Relational Schema...........................................................................................................................3
Referential Integrity Constraints......................................................................................................4
ER Diagram with 3 NF relation.......................................................................................................4
Bibliography....................................................................................................................................5

2
DATABASE SYSTEMS
Data Given
ISBN Title Author_LastNa
me
Author_FirstNa
me
Publisher Dat
e
Editio
n
Medi
a
36985
2
Cosmos Sagan Carl Random
House
198
0
1 Book
74125
8
No Secrets Simon Carly Elektra 197
2
1 CD
65478
9
Symphony
No 3 Dur
Eroica Op
55
Beethoven Ludwig 180
5
1 CD
78965
4
On the
Decay of
the Art of
Lying
Twain Mark Project
Gutenber
g
188
0
1 eBoo
k
25896
3
The
Adventures
of Sherlock
Holmes
Conan Doyle Arthur Project
Gutenber
g
1 eBoo
k
12589
6
The Divine
Comedy
Alighieri Dante Project
Gutenber
g
1 eBoo
k
35795
1
The
Hitchhikers
Guide to
the Galaxy
Adams Douglas Pan
books
197
9
1 Book
85236
9
The Return
of the King,
Soundtrack
Shore Howard Reprise 200
3
1 CD
83197
5
Unseen
Academical
s
Pratchett Terry Doubleda
y
200
9
1 Book
Dependency Diagram

3
DATABASE SYSTEMS

4
DATABASE SYSTEMS
Functional Dependencies
Attribute Dependency
ISBN Title,Author_LastName,Author_FirstName,Date,Edition,
Publisher
Publisher Media
Decomposition of the relation into a set of 3 NF
Books (ISBN (primary key), Title, Author_Last, Name, Author_FirstName, Date, Edition,
Publisher)
Publisher (Publisher (primary key), Media)
Relational Schema

5
DATABASE SYSTEMS
Referential Integrity Constraints
ER Diagram with 3 NF relation

6
DATABASE SYSTEMS
Bibliography
Baixeries, J., Kaytoue, M., & Napoli, A. (2014). Characterizing functional dependencies in
formal concept analysis with pattern structures. Annals of mathematics and artificial
intelligence, 72, 129-149.
Papenbrock, T., Ehrlich, J., Marten, J., Neubert, T., Rudolph, J. P., Schönberg, M., ... &
Naumann, F. (2015). Functional dependency discovery: An experimental evaluation of
seven algorithms. Proceedings of the VLDB Endowment, 8(10), 1082-1093.