28、uary 23, 2009 from http:/www.progressivetech.org/Resources/PDF/Database%20assessment%20and%20planning.pdf7. Database Design (n.d.). Retrieved March 19, 2009 from http:/www.dcs.vein.hu/CIR/cikkek/conceptual_ design.pdf 8. Database Planning (n.d.). Retrieved February 15, 2009, from : .au/database-plan 。

29、ning.htm 9. Database Planning Workbook (n.d.). Retrieved February 15, 2009, from : http:/www.techsoup.org/binaries/files/DatabasePlanningWorkbook.pdf 10. Database Testing: How to Regression Test a Relational Database (n.d.), retrieved February 17,2009, from http:/www.agiledata.org/essays/databaseTes 。

30、ting.html11. David Avison & Hanifa Shah, 1997, Information Systems Series - The Information Systems Development Life Cycle: A First Course in Information Systems, London;
McGraw-Hill12. Davor Gornik, Entity Relationship Modeling with UML (November 3, 2006). Retrieved March 15, 2009 from : 13. Gilmor 。

31、e, An Introduction to Database Normalization (November 27, 2000). Retrieved February 15, 2009, from 14. John Archibald, Our Approach toDatabaseDesign and Development - A road map to better information management. Retrieved February 23, 2009 from S:15. Microsoft SQL Server, Retrieved February 13, 200 。

32、9, from Wikipedia: http:/en.wikipedia.org/wiki/SQL_Server_200516. Primary Key (n.d.). Retrieved March 15 from TechTarget: 17. Relational Model (n.d.). Retrieved February 13, 2009, from Wikipedia: http:/en.wikipedia.org/wiki/Relational_model18. Thomas Connolly & Carolyn Begg, Database Systems A Pract 。

33、ical Approach to Design, Implementation, and Management (Third Edition), Beijing: Publishing House of Electronics Industry, p.25319. Thomas Connolly & Carolyn Begg, Database Systems A Practical Approach to Design, Implementation, and Management (Third Edition), Beijing: Publishing House of Electroni 。

34、cs Industry, p.33320. Thomas Connolly & Carolyn Begg, Database Systems A Practical Approach to Design, Implementation, and Management (Third Edition), Beijing: Publishing House of Electronics Industry, p.34221. Thomas Connolly & Carolyn Begg, Database Systems A Practical Approach to Design, Implemen 。

35、tation, and Management (Third Edition), Beijing: Publishing House of Electronics Industry, p.35322. Thomas Connolly & Carolyn Begg, Database Systems A Practical Approach to Design, Implementation, and Management (Third Edition), Beijing: Publishing House of Electronics Industry, p.37023. Unified Mod 。

36、eling Language (n.d.). Retrieved February 13, 2009, from Wikipedia: http:/en.wikipedia.org/wiki/Unified_Modeling_LanguageAcknowledgementUpon completing the writing of my undergraduate dissertation, I would like to give my sincere gratefulness to many people. First of all, I would like to thank my in 。

37、structor, Ms. Joanne Zhang for giving me guidance and instructions when I was writing this thesis. Secondly, I would like to thank all authors of the articles from which I got inspirations or direct help. Besides, I would like to thank all staff working in KangBei Gymnasium for kindly providing me w 。

38、ith not only detailed information but also encouragement needed for my dissertation. Finally, I would like to thank my friends in college and workmates in North China Power Equipment and Material Central Corp where I worked as intern for offering me possible solutions and support when I met problems 。

39、. Zhu WeiAppendixAppendix A. Data Dictionary1. Entity TypesEntityDescriptionOccurrenceStaffAll staff- Each staff belongs to a department.- Some staff manage departments.- Each staff has salary.- Some staff are trainers.- Some staff are instructors.- Some staff receive members.- Some staff contact su 。

40、pplier.DepartmentAll department- A department is managed by a staff.- Department has staff working for.TrainerTrainer- A trainer is a staff. - A trainer trains at least one member.InstructorInstructor- An instructor is a staff. - Instructor teaches at least one class.SalarySalary information- Each s 。

41、alary belongs to one staffMemberPerson who registers membership- A member is received by a staff.- A member has at least one card.- A member issues registration for a class.- A member has at least one physical test.- A member have a trainer.- A member can purchase commodity.CardThe card a member had 。

42、/has.- One card is held by one member.PhysicalTestTests for members physical condition.- A physical test is for one member.SupplierSuppliers for the facilities- Supplier provides equipments.- Supplier provides commodity.- Supplier is contacted by staff.EquipmentThe equipments - Equipment is supplied 。

43、 by suppliers.CommodityThe commodity for purchase- Commodity can be purchased.- Commodity is supplied by supplier.ClassAll class- Class can registered by members.- Class takes room.- Class is taught by one instructor.RoomThe room for class- Each room is for at least one class.PurchaseThe commodity a 。

稿源：(未知)

【傻大方】网址：/a/2021/0621/0022536368.html

标题：数据库|数据库的设计、实现和管理健身房数据库系统( 三 )