Ask a question from expert

Ask now

ITECH 1006 Database Management Report Assignment

8 Pages1051 Words179 Views
   

Federation University Australia

   

Database Management Systems (ITECH 1006)

   

Added on  2020-05-28

ITECH 1006 Database Management Report Assignment

   

Federation University Australia

   

Database Management Systems (ITECH 1006)

   Added on 2020-05-28

BookmarkShareRelated Documents
[Name][Roll no]Great Southern Research Institute –Database management report
ITECH 1006 Database Management Report Assignment_1
Great Southern Research Institute (GSRI) Table of ContentsER diagram.......................................................................................................................3Assumptions......................................................................................................................3Normalization and relationships.......................................................................................3One to One..................................................................................................................................3One to Many...............................................................................................................................4Database schema...............................................................................................................5References.........................................................................................................................82
ITECH 1006 Database Management Report Assignment_2
Great Southern Research Institute (GSRI) ER diagramAssumptionsFollowing are key assumptions of the proposed database:A document can be written by one or more authors.An author can write one or more documents.A payment can only of one type but project can make one to many types of paymentNormalization and relationshipsOne to OneRelationship 1:-CLIENT(uniqueID, cName, address, phone, email, contactName, clientType )-CLIENT_TYPE (tName, description)Relationship 2:-DOCUMENT(uniqueID, dName, referDoc, projectID)3
ITECH 1006 Database Management Report Assignment_3

End of preview

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

Related Documents
Database Management System
|25
|1773
|306

ITECH 100 Database Management System (DBMS) Assignment
|15
|1416
|357

H16W 35 Relational Database Management Systems
|16
|1641
|138