logo

ITECH 100 Database Management System (DBMS) Assignment

15 Pages1416 Words357 Views
   

Federation University of Australia

   

Programming Assignment (ITECH1000)

   

Added on  2020-05-28

ITECH 100 Database Management System (DBMS) Assignment

   

Federation University of Australia

   

Programming Assignment (ITECH1000)

   Added on 2020-05-28

ShareRelated Documents
Running head: DATABASE MANAGEMENT SYSTEMDBMS - Database Management System: A Case study of Great Southern ResearchInstitute (GSRI)Student Name: [Please Fill]Student Number: [Please Fill]Name of the Tutor: [Please Fill]
ITECH 100 Database Management System (DBMS) Assignment_1
DATABASE MANAGEMENT SYSTEM1Table of Contents1. ER Diagram for GSRI Database..................................................................................................22. Assumptions................................................................................................................................33. Normalization..............................................................................................................................34. Relational Schema.....................................................................................................................10Bibliography..................................................................................................................................16
ITECH 100 Database Management System (DBMS) Assignment_2
DATABASE MANAGEMENT SYSTEM21. ER Diagram for GSRI DatabaseStaff_MemberClientClient_TypeProjectProjectLeadExpenseDocumentDocument_TypeClient_ProjectStaffWorkPaymentS_IDPKS_FNameS_LNameS_PhNumberS_AddressS_EmailS_TNumberS_JobTitleS_WeeklyRateOfPayC_IDPKC_FNameC_LNameC_PhNumberC_AddressC_ContctNameC_TypeIDFKC_TypeIDPKCT_NameCT_DescriptionProj_IDPKP_NameStart_DateEnd_DateP_ProgressTypicalProjectValueP_DescriptionLead_IDPKNameEmailExpense_IDPKAmountPayeeDescriptionDateDoc_IDPKDocuentTitleTypeIDFKAuthorNameD_TypeIDPKNameDescriptionClientPaymentGovernmentPaymentDonationPay_IDPKAmountDatePay_IDPKC_IDFKReferenceNumberPay_IDPKGovernmentDepartmentNameContactNumberPay_IDPKDonorNameAddressEmailC_TypeIDFKPKStart_DateEnd_DateS_IDFKPKProjIDFKPKProj_IDFKPKNotesStart_DateEnd_DateNotesProj_IDFKProjIDFKProj_IDFKIS AFigure 1: ER Diagram of GSRI Database
ITECH 100 Database Management System (DBMS) Assignment_3
DATABASE MANAGEMENT SYSTEM3(Source: Created by Author)2. AssumptionsDuring the development of ERD the assumptions those have been made are as follows: a)Between the start and end date of the project the payment should be done by thepayee.b)The project could have different types of clients c)Various payments are also available for one project d)Non staff member can also be the lead of the project 3. NormalizationFirst Normal form: Each entity associated to the table must have an atomic value to be infirst normal form. The database does not have any multivalued attribute which reflects that it isin first normal form.Staff_MemberS_IDS_FNameS_LNameS_PhNumberS_AddressS_EmailS_TNumberS_JobTitleS_WeeklyRateOfPayStartDateEndDateNotesClientClientID
ITECH 100 Database Management System (DBMS) Assignment_4

End of preview

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

Related Documents
ITECH 1006 Database Management Report Assignment
|8
|1051
|179

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

Database Management System
|25
|1773
|306

Entity Relationship Diagram of TopFit (Source: Created by au
|11
|1283
|188

Database Designing Experience for Business Entity-Relationship Modelling Module Tutor - Report Declaration
|11
|1108
|78

ITECH 1006 - Database Management Systems FUA
|7
|741
|205