3NF范式实验报告.doc

实验报告学院（系）名称：计算机与通信工程学院姓名王康学号20095669专业计算机科学与技术（中加）班级教学5班实验项目数据库设计 (二)课程名称Information System课程代码0666066实验时间2011-4-25实验地点7号楼219批改意见成绩教师签字：软件环境：Windows XP/Windows 2000；Visible Analyst/Visio/Office 2000。硬件环境：CPU Pentium III以上，内存 128MB以上；硬盘 10GB以上实验目的：1. 熟悉E-R图的绘制；熟悉数据库设计的基本步骤；掌握关系规范化的要求和方法（包括1NF、2NF和3NF）；2. 学会使用Access创建关系表.实验内容TopText PublishingSituation: TopText Publishing is a textbook publishing company with a headquarters location, a warehouse, and three sales offices that each has a sales manager and sales representatives. TopText sells to schools, colleges, and individual customers. Many authors write more than one book for TopText, and some books are written by more than one author. TopText maintains an active list of over 100 books, each identified by a universal code called an ISBN number.1. Consider the following entities: authors, books and warehouse, and draw an ERD for the TopText information system. (Data about the managers, sales representatives, customers, orders, and offices probably would be kept in a separate system, such as a human resources information system (HRIS).)2. Identify all fields you plan to include in the tables.3. Design initial tables (i.e. transfer each element into corresponding table) and identify the likely primary key for each table4. Design 3NF table. 5. Create the these table using Access 2000实验要求：（1）按题目要求独立完成实验。（2）按照要求一周之内完成实验报告，并上交的实验报告的纸制版（3）要求字迹工整、表述清楚。实验过程与实验结果（可包括实验实施的步骤、算法描述、流程、结论等）1. 建立ERD2. 建立初步表3.设计3NF 表顾客表单 主键为 顾客编号订单表 主键为 订单编号 和 IS