Running head: DATABASE MANAGEMENT FOR BUSINESSDatabase Management for BusinessName of the StudentName of the UniversitySignature of the Students:
DATABASE MANAGEMENT FOR BUSINESS1Table of ContentsEntity Relationship Diagram:2Relational Structure:2Relational Database Schema:4Description:7Bibliography:9
DATABASE MANAGEMENT FOR BUSINESS2Entity Relationship Diagram:Advertising_OrderOrderMagazine_IssuePaymentsAdvertiser_ClientEditorial_AddressInvoicing_AddressDesign_AgencyAdvertising_AgencySuppliersStaffOrder_PaymentPurchase_Order_NumberPKOrder_dateSales_representativeSpecial_InstructionCopy_NotesOrder_IDPKInvoice_DateMagazine_IssueCost_PricePage_SizeShapeColourPositionProduction_NotesIssue_IDPKPublication_NameIssue_YearIssue_MonthPayment_IDPKAmountDateCheque_NumberCredit_Card_TypePayment_MethodCredit_Card_NumberCredit_Card_NameExpiry_DateAdvertiser_IDPKCompany_nameWebsite_addressBusiness_Phone_numberFaxContact_First_NameContact_Second_NameContact_TelephoneContact_FaxStreet_NameCityStatePost_CodeAdvertiser_IDFKPKStreetCityStatePostcodeAdvertiser_IDFKPKStreetCityStatePostcodeAgency_IDPKCompany_NameContactPhoneEmail_AddressAgency_IDPKBusiness_NameContact_NameMobile_NumberAdvertising_AgencyFKDesign_AgencyFKBusiness_NumberFaxAgency_CommissionSupplier_IDPKCityStatePost_CodeCityStatePost_CodeCompany_NameContact_NameTitleStaff_IDPKTax_File_NumberEmail_AddressNamePhoneAddressOrder_IDFKPaid_AmountDue_AmountPayment_IDFKOrder_IDFKFigure 1: Entity Relationship Diagram(Source: Created by Author)
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Data and Information Management Assignmentlg...
|8
|1379
|259
Database Management System: Case Study of BigM Systemlg...
|12
|1280
|412
Database Designing Experience for Business Entity-Relationship Modelling Module Tutor - Report Declarationlg...