Lectur和e 7 DB.pptVIP

Database Design Design criteria Ease of access Steps for database design Identify information Organise into logical groups Establish relationships between tables Create index Define validation rules Data Modelling Normalisation Introduction to E-R Modelling: Entities, Attributes, Relationships, Temporal Data, Inheritance Relational Data Model: Terminology, Codd’s Rules Logical Database Design: Relational Theory, Normalisation Database Design Model Data Modelling using the ER Model Entities Person: employee, student, lecturer Place: country, state, city Object: car, machine, component Event: registration, examination Concept: account, course Entity Type Instances Attributes Keys Relationships Degree of a relationship Identify Define Attributes Generalisation Data Modelling Exercise University Student Recreation Centre Database Students can only use the centre if they have paid their recreation fees in full. The centre will also allow a faculty to purchase a membership as well. Members are allowed to check out sports equipment such as basketballs, softball bats and balls, tennis rackets, badminton rackets and table tennis rackets that can be used at the facility. When the members check out equipment, an equipment-issue form is completed listing the membership number and equipment being used. This form must list at least one piece of equipment in order to be retained in the file. Otherwise it is discarded. A member of staff is employed to monitor the checkout and the use of the sporting equipment. Every employee is assigned to one of two departments: maintenance or general staff. The centre has 10 tennis courts. These courts may be reserved up to one week in advance. Reservations can be made via the equipment checkout window. The centre also operates a small accessory shop where some sporting equipment and clothing is sold. The sporting goods include tennis balls, table tennis balls, bandages, etc. Sportswear bearing the un