资源描述：
《Database Management System_Sample Database Project》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、FirstNameLastName****PLEASECITETHISREFERENCEWHENDONINGYOUROWNPROJECTSProf.FernandezDatabaseProjectxx/xx/xxxxCarSalesBusinessCase:Thedevelopeddatabasewillbedeployedinacarsalescompany.Thecompanywillbenefitfromusingadatabasebecauseofthefollowing:1Customero
2、remployeeswillbeabletosearchquicklyforcarsthatmatchestheircriteria.2Withouttheuseofdatabase,customers/employeeswillhavetobrowseeachcaruntiltheyfindtheneededone.3Byusingthedatabase,employeescancreatemeaningfulreportsusedbycompany.Examplesofthosereportsar
3、e:fastsoldcars,leastsoldcars,mostsoldcars,bestemployeesales,andsoon.4Incasethecompanyhastensorthousandsofcars,thedatabasewillstillscalewell.5Employeeswillbeabletoeasilymanagethedatabase.Thecompany’sdatabasewillhavetomanagecustomers,employees,carsforsale
4、,soldcars,andinvoices.Employee/Customersinformationwillbeabletobeaddedandupdatedinthedatabase.Inaddition,thedatabasewillmaintainthecurrentcarsforsale.Italsoholdshistoryofcarsthathavebeensold.Lastly,itwillmanageinvoicesissuedwhenacarsaleoccurs.Database:T
5、hroughouttheproject,OracleDataModelwillbeusedtocreatethedatabase.Moreover,OracleSQLDeveloper11gwillbeusedtomanagethedatabase.Hardware:DellIntelCore2Duo2.4GHzProcessor4GBDDR3Memory320GBStorageSoftware:Windows7ServicePack2DataFlowDiagram(DFD):EmployeeInfo
6、2UpdateExistingCustomerStore3UpdateExistingupdatedEmployeeStorecustomeD2CustomerupdateD3EmployeerinfoinfoStoreStorenewcustomerinfonewUpdateUpdateemployexistingexistingeeinfocustomeremployee1AddNewCustomer4AddNewEmployeeCreateCustomerCreatenewcustomerEmp
7、loyeenewemployeeupdatecarAddcarCreate5NewSalenewSaleCustomerInfoStoresold6AddNewCar7UpdateCarInfocarD5SoldCarsCarinfoStoreupdatedcarStorecarcreateinvoiceupdateremove9CreateInvoiceD1CarsForSaleinventory8UpdateCarStocksoldcarStoreinvoiceD4InvoiceForabette
8、rview,IhaveattachedalargerDFDinCar_Sales_DFD.pdfdocument.Entities:1Customer:eachinstanceofthisentitywillrepresentacustomertothecarsalescompany.EachcustomerwillhaveaCustomer_ID,LName,FName,Address,State,Zipcode,andPhoneattributes.
