MIS 实验报告2_English Implementing a database with Microsoft Acc.doc

Experiment Report Project name Implementing a database with Microsoft Access Laboratory 　 Computer Lab 　 Affiliated course Management Information System Experiment type Integrated Experiment Date 2013/11/28 Class 计算机科学与技术 Student No 2012114217 Name 娄嘉宇 Grading Experiment Overview： 【Experiment objectives and requirements】 1. Identify The Steps Necessary To Implement The Structure Of A Relational Database Using The Data Definition Language Provided By Microsoft Access. 2. Demonstrate How To Use The Data Manipulation Subsystem In Access To Enter And Change Information In A Database And How To Query That Information. 3. Explain The Use Of The Application Generation Subsystem In Access To Create Reports And Data Entry Screens. 【Experiment principle】 Using Microsoft Access implement Solomon Enterprises Database. 【Experiment environment】（used hardware and software） Hardware: Desktop or laptop Software: Windows XP and Microsoft Access. Experiment content： 【Experiment solution design】 The steps of designing and implementing the correct structure of a relational database include: 1. Define entity classes and primary keys. 2. Define relationships among the entity classes. 3. Define information (fields) for each relation (the term relation is often used to refer to a file in the context of a database). 4. Use a data definition language to create your database. 【Experiment procedure】（experiment steps, record, data and analysis） Implementing the structure of the Solomon enterprises database Implementing the raw material relation structure Implementing the concrete type relation Implementing the bill of material relation Defining relationships within the Solomon enterprises database Entering information into the Solomon database Changing the structure of information in relations