Database Management Systems_Assignment 1 Solution

Assignment 1
1 DatabaseManagementSystems(10marks)
Consider the following relational schema about Kids (Campers) that register for Summer Camps in Adventures in Science in Engineering at uOttawa.
Camper(CName : string,Age : string,Email : string,tshirt : string,Fee : real) Camp(CampID : int,CampTitle : string,EmpID : int,StartDate : date,Year : date) Signup(CName : string,Name : string) Mentor(EmpID : int,Name : string,EmploymentDate : date,Salary : currency)
TheDatabaseManagementSystem(DBMS)provide,amongstothers,thefollowingfivefunctions:
1. Uniform data administration, 2. Data independence, 3. Data integrity, 4. Concurrent access, and 5. Data security.
Explain, by using of your own examples against the database, exactly what each one of these five functions ensure.
1
2 EntityRelationshipDiagrams(15marks)
ConsiderthefollowingdescriptionoftheGoGoGreenelectricscooterrentalcompanythatisbased in Ontario. The headquaters is in Ottawa and GoGoGreen currently has ten branches throughout the province.
• Each branch has an inventory of electric scooters, all of which are recorded in a catalog. • For each scooter, we record the unique registration number, the make (e.g. Suzuki), the model (e.g. Dolce Vita), the year of manufacturing (e.g. 2015), the rental price per hour (e.g. $12.00 per hour), the main color (e.g. red) and the battery duration (e.g. 100 hours). • Abranchmayhavemanyscootersofthesamemakeandmodel,buttheregistrationsnumber is unique throughout the company. • Before renting a scooter from the company, a customer must first register as a member of a local branch. The data held on a member include her membership number, name, address, phone number and the date she first registered at the branch. We also record credit card details. • Once registered, a member is free to rent a scooter for a duration from (minimum) 1 hour to (maximum) 48 hours. • The data held on each scooter rental is the rental contract number, the date, the membership number, the registration number of the scooter, the daily rental price, as well as the time rented out and returned. A status attribute is used to indicate whether a scooter is available or not. • For each branch we record the branch number, name, address and phone number. • Each branch has a manager, who is responsible for the day to day running of the branch. A branchalsohasatleasttwoadditionalstaffmembers,whoarefull-timeemployees. Foreach staff member, we record her name, address and social insurance number.
Draw an EER diagram for the GoGoGreen database, using the description given above. Show all yourassumptionsclearly.