Scenario: Canberra Driving School
Canberra Driving School (CDS) was established recently. CDS has five branches in Canberra. CDS requires your team to design a database system to enable more smooth operation of the centre. The details of the branches of CDS are:
Branch name Address
CDS Downer 50 Cadell St, Downer, 2602, ACT
CDS Phillip 12 Athllon Dr, Phillip, 2606, ACT
CDS Belconnen 390 Benjamin Way, Belconnen, 2617, ACT
CDS Civic 12 Alinga St, 2601, City, ACT
CDS Bonner 61 Mabo Blvd, 2914, Bonner, ACT
CDS database will record and store the data about each of its clients and instructors including their first and last name, postal address, and home address (street number, street name, suburb, post-code, city), sex and type of driving classes a client is enrolled in. The name (first and last name), contact telephone number and address (street number, street name, suburb, post-code, city) of client’s next-of-kin is also
stored in database.
CDS offers several types of driving classes. Driving classes are managed under course development section of CDS. There exist several types of driving classes. These are namely Class A (Trucks), Class B (Mini Trucks) and Class C (normal passenger vehicles). A client can be enrolled in up to two different classes at any time.
Each class type has different fees. CDS database will record and store the data about each of its classes.
Clients need to book for each class up to two weeks beforehand. The timetable and availability of each instructor is provided on CDS website.
When a client enrols at CDS he or she is assigned a client number and his/her details are recorded. Every client is provided with a client number and an ID-card as well as the rules of CDS and charges. Each class type has its own terms and conditions. A client can use his/her client number to book a class (using the online booking facilities).
CDS has several staff members in each branch. For each staff member the following data is stored in the database system: staff first and last name, staff number, position, sex, date of birth, name of the section and branch number he/she works in as well as each staff internal telephone number. Each branch has a manager. Detail of each manager for each branch is also stored in CDS database.
CDS has also several instructors in each branch. For each instructor the following data is stored in the CDS database system: staff first and last name, instructor number, position, sex, date of birth, type of driving classes that an instructor can teach (i.e., Class A, B or C), internal telephone number and branch number.
CDS consists of four sections. These sections are: instructor section, information and course development section, assessment and enrolment section, administration section. The information about each section is stored in the CDS database. The information about each section includes the section name, location, telephone and fax number. CDS clients can browse the CDS website to find out the details of all classes available for each week.
Instructors belong to the instructor section. Each instructor is limited to teach a maximum of two types of classes at any day. The instructor’s identity is established with their ID number and ID-card and it is used to retrieve the details of the classes that they teach. The details of each class (class number, Instructor ID number, date and time, details of the clients for each instructor) are stored in the CDS database. If a staff, instructor, or a client loses his/her ID-card, he/she then contacts the CDS at the
following telephone number: 188473635. The staff at administration section once notified will deactivate the lost ID-card and a new ID-card is issued later. Issue of a new ID-card may take up to 24 hours. When a new card is issued the details of the staff in administration section that issued the card is recorded in CDS.
The details of all lost card stored in CDS database is: first name and last name of staff who issued the new ID-card, date, and time that the card was issued and staff first and last name of the staff that has lost his/her card.
This G6672 - IT Assignment has been solved by our IT experts at TV Assignment Help. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
Proofreading and Editing$9.00Per Page
Consultation with Expert$35.00Per Hour
Live Session 1-on-1$40.00Per 30 min.
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....