Your Status: Logged out Log in

Create a Database based on a case study scenario on a language summer school.  

Member rating: No Rating | Words: | Submitted: Mon Jun 06 2005

Page Preview
Preview
Previous 1 of 21 Next

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...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 149,410 others
Register Now