Find Jobs
Hire Freelancers

Advanced Database Systems(repost)

$30-40 USD

Cancelled
Posted about 13 years ago

$30-40 USD

Paid on delivery
## *Preamble* *It is primarily an exercise in database design and implementation using Oracle Designer and Oracle SQL*Plus, and in documentation of the system. * ***The use of any other database products such as MS Access or MYSQL for any parts of this work is not allowed.*** *2>? nl?? ??>* * * *Your system will be developed using Oracle Designer and Oracle SQL Plus * * Sunrise College* is a reputable language institute specialising in providing foreign language courses at various levels to the general public. It consists of several local centres in and around London. At present, course enquiries and bookings are managed centrally by the College on a semi-automated basis, namely, they are handled by a largely paper-based file system, supported partially by a basic computer system. Acutely aware of the limitations of the current regime and keen to improve the quality of the services, the College has approached Rising Star Ltd, an up-and-coming software house based in the City of London, with a request to develop a well designed database system to enhance course management at the College. You have been sub-contracted by Rising Star, since you are registered on its list as a freelance Database Developer, to design and implement a prototype of the database system for the College. On completion of the system, you are required to provide a full set of system documentation. Your system will be developed using Oracle Designer and Oracle SQL Plus ## Deliverables *Sunrise College* is a reputable language institute specialising in providing foreign language courses at various levels to the general public. It consists of several local centres in and around London. At present, course enquiries and bookings are managed centrally by the College on a semi-automated basis, namely, they are handled by a largely paper-based file system, supported partially by a basic computer system. Acutely aware of the limitations of the current regime and keen to improve the quality of the services, the College has approached Rising Star Ltd, an up-and-coming software house based in the City of London, with a request to develop a well designed database system to enhance course management at the College. You have been sub-contracted by Rising Star, since you are registered on its list as a freelance Database Developer, to design and implement a prototype of the database system for the College. On completion of the system, you are required to provide a full set of system documentation. Your system will be developed using Oracle Designer and Oracle SQL Plus ### 2. Case Study Sunrise College offers courses for various foreign languages, including French, German, Spanish, Italian, Russian, Japanese, Chinese and so on. Each course is identified by a unique course code, and designated with a particular level (Introductory, Intermediate, or Advanced). Furthermore, each course is run at only one centre of the College and taught by one lecturer. However, a lecturer may teach at more than one centre if necessary. A potential student will initially make an enquiry to one of the Course Officers at the Central Enquiry Unit of the College. A brief conversation with the student will normally enable the Course Officer to ascertain the course in which the student is interested, and to identify an appropriate level for the student. The Course Officer will then check the cost and dates of the course, and enter the details in a Course Booking Form together with student infomation. A student may book several courses under the same booking number. Therefore, a Course Booking Form may contain several courses booked by the student. **Figure 1** gives an example of such a Course Booking Form. When the student confirms the booking, a copy of the Course Booking Form will be passed to the Administrative Officer at the Registry of the College, who will prepare a formal Enrolment Form. This Enrolment Form will be sent to the student, together with relevant course information and an invoice for payment. The Administrative Officer will then use the details contained in the Enrolment Form to update the Course Summary Form as given in **Figure 2**. This form provides the most up to date information for each course together with a list of students who have registered for the course so far. A copy of this Course Summary Form will be distributed to the relevant centre and lecturer involved for record keeping. Consequently, each lecturer will be able to extract information from this form to compile his or her own Class Registration List. The Registry regularly produces several other forms on request, including Centre Details Forms, Course Details Forms, Lecturer Details Forms, Student Details Forms, Lecturer Assignment Forms, and so on. The introduction of a fully operational database system will eliminate many of the shortcomings of the current operations and facilitate a much-awaited improvement for the College on its provision of timely course information and efficient course management. # 3. Requirements Marks are awarded for producing a working and properly documented system that meets the requirements specified below as **deliverables**: ## q Contents Page A list of sections/subsections of the document, including page numbers. q **Normalisation** Produce a set of fully normalised tables for the system: * You may use Figure 1 and Figure 2 as a starting point for normalisation. * You may also add additional attributes where appropriate. * show clearly all the steps of normalisation, up to the 3rd normal form. q **E-R Model** Use Oracle Designer to produce an Entity Relationship diagram, consistent with your 3rd normal form tables. Submit a copy of the ER diagram. q **Data Dictionary** Use Oracle Designer to produce a list of attributes for each entity. Submit a print-out copy of these lists. q **Generation of Database** * Use Oracle Designer to covert the E-R diagram into a set of database tables. Provide a print-out of the DDL script for generating the tables ('CREATE' table statements only). * Use Oracle SQL Plus to populate these tables with suitable data values. Provide a print-out of the INSERT statements and of the content of the tables (using SELECT). q **Database Interrogation** Use Oracle SQL Plus to implement the following queries. For each query, submit the SQL script and its output result. * **Centre-Lecturer information**:- For any centre, show details of all the lecturers teaching at the centre together with the courses they are allocated to teach. * **Course-Student information**:- For any course, show the course details and a list of students registered for the course (similar to Figure 2 given). * **Student Booking**:- for any student, show the details of his/her booking including all the courses which have been booked. q **Data Flow (DF) Diagrams** * Use Oracle Designer to produce a Level 0 DFD (frame function) based on the case study. This diagram must include relevant local functions, datastores, dataflows and externals. Submit a copy of this diagram. * Select one local function from the Level 0 DF diagram and expand it into a separate Level 1 DF diagram. The local function selected must include at least one datastore connection. Submit a copy of this diagram. q **Process Diagram (PD)** * Use Oracle Designer to produce a Process Diagram based on the case study. This diagram must include relevant process steps, process flows, data stores and externals. Submit a copy of this diagram. q **Further Discussion** * Briefly summarise your experience in using DFDs and PD for describing the system. Compare these two approaches and discuss their advantages and disadvantages in relation to this case study. * Briefly discuss your own experience in completing this coursework **Your work must be submitted in a single document, with all output including diagrams, tables, SQL scripts clearly labeled and presented.**
Project ID: 3161111

About the project

2 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $34 USD for this job
User Avatar
See private message.
$34 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$34 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
1
Member since Dec 6, 2010

Client Verification

Other jobs from this client

Advanced Database Systems
$30-40 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.