Birmingham Metropolitan College or university
School of Computing
Homework Assignment Header
STUDENT NUMBER: ___________________________________________________
INITIAL NAME AND FAMILY IDENTITY: ______________________________________________________
GRADE ALLOCATED: ____________________N. B. Most grades happen to be provisional until confirmed by the Board of Examiners
ASSESSOR'S INITIALS: ________________________________
Module quantity: CC3005NI
Component name: Advanced Database Devices
Module leader: Dr Farreneheit F Cai
Coursework number: 1 of just one
Weighting: forty percent (% of module examination total)
Date set: 03 2013
Particular date and time due: (date/time)
To Islington College Nepal
This Coursework is definitely an individual analysis. It is generally an exercise in database design and style and implementation using Oracle Designer and Oracle SQL*Plus, and in records of the program.
The use of some other database goods such as MS Access or perhaps MYSQL for almost any parts of this kind of work will mean zero signifies.
You are required to attach to your homework submission the standard header piece with a agreed upon disclaimer.
Submission of Your Job
All your work should be constructed into a single record. It should possess a cover webpage with component title, student name and registration number.
You must fill in your work on or ahead of the published deadline, to RTE at Islington College Nepal. Please make sure to keep your receipt/confirmation and keep a copy of your job.
Please note that plagiarism can be described as serious academics offence, for which penalties happen to be severe. Most suspected circumstances of plagiarism will be reported.
1 . Advantages
Metropolitan School specialises in providing language courses in various levels to the average person. It includes several neighborhood centres around London. At present, course enquiries and bookings are maintained centrally by College on a semi-automated basis, namely, they can be handled with a largely paper based file system, supported partially with a basic personal computer.
The College acknowledges the limitations of its current operations and it is keen to improve the quality of it is services. For this end, the College has approached Leading Edge Ltd, a software home based in the location of Greater london, with a obtain to develop a proper designed database system to boost the quality of study course management with the College.
You could have been sub-contracted by Top rated as a Jr . Database Designer to design and implement a prototype in the database system for the faculty. On completion of the system, you are required to provide a total set of documents of the system to Top rated.
Your modele of the program will be developed using Oracle Designer and Oracle SQL Plus in London Achieved.
2 . Example
The College gives courses for various overseas languages, which include French, A language like german, Spanish, Italian language, Japanese, Oriental and so on. Every single course is associated with a certain level (Introductory, Intermediate, or Advanced). Some of the courses is definitely identified using a course code, but can be run for different zones of the School and educated by several lecturers within the same period. In addition , a lecturer might teach any kind of time of the companies if necessary.
Any student is going to initially call and make an enquiry to 1 of the Training course Officers on the Central Interrogation Unit from the College. A quick conversation with the student will certainly normally allow the Course Officer to ascertain the course in which the college student is interested, and to discover an appropriate level for students.
The Program Officer will then check the cost and date ranges of the study course, together with its availability. Typically, the student will probably be offered to decide on a list of obtainable centres and lecturers that run the same program. Once a choice has been manufactured...