Create a Database based on a case study scenario on a language summer school.
Member rating: No Rating | Words: | Submitted: Mon Jun 06 2005
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
CS2075S DATABASE SYSTEMS: DESIGN AND APPLICATION The aim of this assignment was to create a Database based on a case study scenario on a language summer school. A successful database system had to be implemented holding key information and then querying the database using at least 6 queries. User requirements: * The summer school employs 20 members of staff. The staffs are allocated different jobs including managerial roles. Hall managers & office managers are assigned. * The student records are kept and detained even when they are placed on a waiting list, so that they can be recognised when wanted. * The Renting period can be between 1-12 weeks. The students can pay on a weekly basis. The minimum agreement is 1 week & the maximum being 12 weeks. * The manager needs to know the duration of the lease (i.e. weeks), the accommodation details and the student details * At the start of...

