7CI022 Database Systems & Security

You are required to design and implement a database system for an application area of your choice. For example, it could be a booking type application or an order processing type system (but other suggestions are welcome!). Examples include a system to book tickets for a theatre, a flight or a system to allow customers to hire or buy books, tools, cars or other. We want you to propose a scenario drawn from your own experience. The scenario and the produced database system will be judged by the tutors using the marking schema in the later section of this document. The underlying database should be a relational one (Oracle). We expect you to provide a few example SQL statements, for instance a meaningful query to your database. You are also required to discuss data governance aspects, i.e., security, integrity, ethics and legal issue.

The assignment has two parts: a modelling part and an implementation part. Both have to be contained be in the same assignment report.

Subtasks

Part 1(LO1, LO2) is about the design of your database. You need to do the following 4 subtasks:

1. Choose an appropriate application area or business. Please refrain from reusing one of the scenarios in the description above. Introduce your scenario.
2. Analyse your application area or business. Informally describe potential business rules, scenarios, information needs and the data involved.
3. Use the Oracle Data Modeller to draw an ER model that covers your scenario. At least 4 or 5 entities are expected, including attributes, cardinalities and relationship names.
4. Normalise your database and explain why it is normalised. List table names, primary keys, foreign keys and attributes.

The second part(LO1, LO3) is about implementing your database and legal and ethical aspects of data governance and security related to your scenario. You need to do the following subtasks:

1. Database implementation: Implement the model created in Part 1. The following contentis expected:

   1. Use your database (e.g., Oracle and SQLPlus) to provide the SQL statements to create your tables. Also provide the SQL statements to populate each table with at least one entry. Execute the statements and present their output.
   2. Use your database (e.g., Oracle and SQLPlus) to devise at least 3 SQL queries to retrieve some essential data, covering identified information needs, from your database. At least one of them needs to contain a JOIN (AND) operation across 2 or more tables. Execute the queries and present their output.

2. Security, integrity and ethics aspects: Please discusssecurity, integrity and ethics aspects for the operation of your database and data governance. The following parts are expected:

   1. A general discussion and reflection of security, integrity, and ethical aspect of data governance.
   2. A discussionof security, integrity, and ethical aspect of data governance applied to your scenario.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back!
Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects. Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank