ITECH 100 Database Management System (DBMS) Assignment

Added on - 28 May 2020

  • ITECH1000

    Course

  • 15

    Pages

  • 1416

    Words

  • 146

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 15 pages
Running head: DATABASE MANAGEMENT SYSTEMDBMS - Database Management System: A Case study ofGreat Southern ResearchInstitute (GSRI)Student Name:[Please Fill]Student Number:[Please Fill]Name of the Tutor:[Please Fill]
DATABASE MANAGEMENT SYSTEM1Table of Contents1. ER Diagram forGSRI Database..................................................................................................22. Assumptions................................................................................................................................33. Normalization..............................................................................................................................34. Relational Schema.....................................................................................................................10Bibliography..................................................................................................................................16
DATABASE MANAGEMENT SYSTEM21. ER Diagram forGSRI 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 ofGSRI Database
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 clientsc)Various payments are also available for one projectd)Non staff member can also be the lead of the project3. 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
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document