MIS602 Data Modelling and Database Design | My Assignment Tutor

1MIS602 Data Modelling and Database DesignAssessment 2 Data Implementation – Case StudyThe following case study models a mobile phone company. The company has a number of phones that aresold by staff to various clients. Each phone comes with a plan and each plan has a number of features specificto that plan including:• a call charge … Continue reading “MIS602 Data Modelling and Database Design | My Assignment Tutor”

1MIS602 Data Modelling and Database DesignAssessment 2 Data Implementation – Case StudyThe following case study models a mobile phone company. The company has a number of phones that aresold by staff to various clients. Each phone comes with a plan and each plan has a number of features specificto that plan including:• a call charge in cents per minute (this does not apply to all plans)• a plan duration in months• a break fee if the customer leaves the plan before the end of the plan duration• a monthly data allowance in gigabytesAssumptions that are made for the assignment are:• mobile phones are locked to a plan for the length of the plan durationEntity-Relationship DiagramRelational Model CUSTOMERCALLSMOBILESTAFFTOWERCONNECTPLANCustomerIDCallsIDMobileIDStaffIDTowerIDConnectIDPlanNameSurnameMobileIDPhoneNumberSurnameLocationTowerIDBreakFeeGivenCalledNumberBrandNameGivenBandwidthCallsIDDataAllowanceDOBCallDateJoinedDOBMaxConnMonthlyFeeSexCallTimeCancelledSexSignalTypePlanDurationPhoneHomeCallDurationPlanNameJoinedCallChargePhoneWorkDataUsagePhoneColourResignedPhoneFaxCustomerIDAddressAddressStaffIDSuburbSuburbPostcodeStatePhonePostcodeSupervisorIDCommissionRatePerHour