You are required to follow all the tasks below and complete all, regarding driving tuition for learners and advanced courses for drivers. The report should be put together professionally, that is, include a contents page, each section correctly labelled. Ensure all the diagrams and results are presentable and in a readable format.
| Section and Description | Length/Diagram | Must Complete |
| a) ANALYSIS: analyse the business you are devising the database system for. Describe the business rules, and data involved. | 1 page of A4 | Explain why the data is important to the information system being developed. Related to your specific topic, discuss the legal and ethical issues involved in managing your data. |
| b) Using the Oracle Data Modeller Tool DRAW AN ERD DESIGN: AT LEAST 4 OR 5 entities ARE EXPECTED. Include cardinalities, attributes and relationship names. | ER (Logical) diagram | Ensure the diagram is readable. |
| c) List the relational headings | 1page of A4 | Your tables must match your ERD. Select suitable primary keys for every table. |
| d) Use ORACLE create your database (ensure you save your CREATE TABLE statement). Highlight any additional constraints added. Ensure AT LEAST ONE table has a COMPOSITE PRIMARY KEY. | SQL script | The primary and foreign keys should be added at the same time as your CREATE TABLE statement, i.e., do not use ALTER TABLE to add them after. Do not use any other DBMS other than Oracle |
| e)Populate all the tables with data (having 8 or more rows per table). Show all rows, (use SELECT * from tablename ;) of data in every table created. | Good/suitable TEST DATA created. Note, the tables at the many end of a relationship should contain more data. | |
| SQL QUERIES: Devise 3 SQL queries that demonstrate appropriate use of the following: f)use of the BETWEEN logical operator; g) a DATE function; h) a SUBQUERY. At least one of the above queries should include data from more than one table. | include the following for each query: - short sentence saying what the query is doing; - SQL query; - results | Results to be formatted appropriately) Good examples and show the deliverables. Must show SQL commands execution. SQL commands must answer the question or test the functionality in the exact manner the question asks for. Use a COURIER font to present the results |
| Pick one data manipulate command (DELETE, INSERT OR UPDATE) and: f) Devise a command that tests either a primary key or foreign key constraint. Explain any error message. | Include the query and comment on any results. Show at least 2 queries: one that work successfully and one that does not. |