logo

ER diagram & Normalization

9 Pages1683 Words96 Views
   

Federation University Australia

   

Database Management Systems (ITECH 1006)

   

Added on  2020-03-02

About This Document

In this document, we will discuss ER Diagram and Normalization. Also, we include three steps of normalization in which we cover the following steps; elimination of repetitive groups in each relation to form subsequent relations and eliminating any partial dependencies such that all non-candidate keys have to be determined by a candidate key. 

ER diagram & Normalization

   

Federation University Australia

   

Database Management Systems (ITECH 1006)

   Added on 2020-03-02

ShareRelated Documents
ER diagram & Normalization_1
MARTIN KINUTHIA[COMPANY NAME][Company address][DOCUMENT TITLE][DOCUMENTSUBTITLE]
ER diagram & Normalization_2
ContentsER Diagram..................................................................................................................................................22 Normalization...........................................................................................................................................3Staff.........................................................................................................................................................3Courses....................................................................................................................................................3Course_types...........................................................................................................................................3Course_prerequisites...............................................................................................................................3Members.................................................................................................................................................4Enrollment...............................................................................................................................................4Classes.....................................................................................................................................................4Member_classes......................................................................................................................................4Member_account....................................................................................................................................5Payments.................................................................................................................................................5Awards.....................................................................................................................................................5Member_awards.....................................................................................................................................53 Conversion of ER to relational schema.....................................................................................................6
ER diagram & Normalization_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Design, Normalization and Data Dictionary for Festival Database
|14
|2021
|90

Database Modelling for International Office of Victoria University
|13
|1540
|390

Achieve Scheme Database Analysis and Design
|9
|2172
|56

Database Design Process for Victoria University Accommodation Department
|15
|1568
|291

Database Modelling: Assignment
|12
|2283
|241

Database Modelling and Implementation for Desklib
|14
|2041
|343