资源描述：
《数据库课程设计论文》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、华南农业大学课程设计报告项目名称：数据库系统课程设计项目性质：课程设计计划学时：所属课程名称：数据库系统xxxx学年第二学期授课学生：授课人数：90人指导教师：课程设计成绩单小组成员、组内分工及各成员成绩学号1992姓名浅风分工成绩90学号姓名XXX分工成绩题目简单零售连锁店配送管理系统设计与实现教师评语评价指标：l数据库设计水平Bl后台程序设计水平Al测试详尽及结果合理Al报告清晰和分析详尽A报告正文1、SystemRequirementSpecification(简单需求说明)AtruckingcompanycalledTRUCKERSisresponsibleforpicki
2、ngupshipmentsforwarehousesofaretailchaincalledMAZEBROTHERS,anddeliveringtheshipmentstoindividualretailstorelocationsofMAZEBROTHERS.Currentlythereare6warehouselocationsand45retailstoresofMAZEBROTHERS.Adatabaseisbeingdesignedtokeeptrackoftruckusageanddeliveriesandtobeusedforschedulingtruckstopro
3、videtimelydeliveriestostores.Thefollowinginformationhasbeenobtained.·Atruckmaycarryseveralshipmentsduringasingletrip,whichisidentifiedbyaTrip#,anddeliversthoseshipmentstomultiplestores.·Asingletripcanloadshipmentsfromseveralwarehousesidentifiedbytheirlocations.·EachshipmentisidentifiedbyaShipm
4、ent#,andincludesdataonshipmentvolume,weight,destination,etc.·Truckshavedifferentcapacitiesforboththevolumestheycanholdandtheweightstheycancarry.·TheTRUCKERScompanycurrentlyhas150trucks,andatruckmakes3to4tripseachweek.ER图参考答案：WAREHOUSElocationMFROMweight-capacityvol-capacitydateNtrip#TRIPNTRUCK
5、-USED1TRUCK1truck#INCLUDESaddressstorenameNSHIPMENTMDESTINATIONNSTOREshipment#volumeweight2、根据综合性设计性实验设计的ER图及相应的关系表，写出创建关系表的SQL语句。并插入一些测试用数据。关系表：t_WAREHOUSE=(location)t_TRIP=(tripID,tdate，truckID)t_SHIPMENT=(shipmentID,volume,weight,tripID)t_TRUCK=(truckID,vol_capacity,weight_capacity)t_STORE=
6、(storename,address)t_FROMS=(location,tripID)t_DESTINATION=(shipmentID,storename)createtablet_Shipment(shipmentIDvarchar(30)primarykey,volumeNumeric(5,0),weightNumeric(5,0),tripIDvarchar(30));createtablet_Trip(tripIDvarchar(30)primarykey,tdatedatetime,truckIDvarchar(30));createtablet_Truck(truc
7、kIDvarchar(30)primarykey,vol_capacityNumeric(5,0),weight_capacityNumeric(5,0),);createtablet_WAREHOUSE(locationvarchar(30)primarykey,);createtablet_STORE(storenamevarchar(30)primarykey,addressvarchar(30));createtablet_FROMS(locationvarc
