Find Jobs
Hire Freelancers

Advanced Database Systems(repost)

$30-40 USD

Anulowano
Opublikowano około 13 lat temu

$30-40 USD

Płatne przy odbiorze
## *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.**
Identyfikator projektu: 3161111

Informację o projekcie

2 ofert
Zdalny projekt
Aktywny 13 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
2 freelancerzy składają oferty o średniej wysokości $34 USD dla tej pracy
Awatar Użytkownika
See private message.
$34 USD w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
See private message.
$34 USD w 10 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED KINGDOM
United Kingdom
5,0
1
Członek od gru 6, 2010

Weryfikacja Klienta

Inne pracę od tego klienta

Advanced Database Systems
$30-40 USD
Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.