Database Systems Report - Module Name - [University Name]

This report presents a detailed analysis of database systems. It begins with a dependency diagram and explores functional dependencies within a given dataset. The report then discusses the decomposition of the relation into a set of 3NF (Third Normal Form), a crucial step in database design to minimize data redundancy and improve data integrity. Following this, the report outlines the relational schema, which defines the structure of the database tables, including attributes and data types. Referential integrity constraints, which ensure the consistency of relationships between tables, are also addressed. The report includes an Entity-Relationship (ER) diagram representing the 3NF relation, visually depicting the entities, attributes, and relationships within the database. Finally, a bibliography of relevant sources is provided to support the analysis. The report covers key concepts in database design and implementation, including data normalization and relational database modeling.

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.