Task 1: – 450 words
Report of basic principles, differences, advantages and disadvantages of the key database types.
This should include but not be limited to relational and NoSQL databases, including the various
sub-types of NoSQL databases, data warehouses and data lakes.
Recommend which type of database should be used for specific applications and systems,
justifying your choice.
Diagrams and figures need to be included
Task 2: Database modelling – 650 words
Based on scenario:
Conceptual Data Model to draw a complete Logical Data Model, again using
“Crow’s Foot” notation, which describes the detailed data requirements for the scenario –
Ideally your Logical Data Model should have 7 or 8 entities with supporting attributes and
relationships.
Explain, using supporting diagrams and sample data as appropriate, how your Logical Data
Model meets the requirements of 1st, 2nd and 3rd Normal Forms – If necessary, correct your
Logical Data Model to meet the requirements.
Document the steps to create both models and meet the Normal Form requirements, providing
supporting explanation, assumptions and comments.
Use Draw.io or another suitable drawing tool to document your models.
Task 3: Database design – 450 words
Use your Logical Data Model to create and populate a relational database, using whichever dialect of
SQL is appropriate for the RDBMS you have selected.
The database should have:
5
At least 7 to 8 tables, one for each entity in the Logical Data Model.
Each table should be populated with a realistic set of sample data, at least 5 records in each
table, possibly more, to enable it to be tested.
Test that your SQL executes successfully and produces the expected results as this will be part of the
marking criteria.
Include evidence that the SQL queries have executed successfully, using screenshots of
results/messages as appropriate, in the main report.
Include the SQL script as text in the appendices so that your marker can copy/paste/execute/test
the code in the relevant RDBMS.
Task 4: Database queries – 450 words
Identify and briefly describe five business requirements for your application. For each requirement, write
a query using SQL, to obtain the relevant information/results or perform the appropriate task.
Collectively, your queries must demonstrate your ability to:
Display data (SELECT)
Manipulate, format and present data (Functions)
Combine data from several tables (JOIN)
Report basic statistics (Summarized Queries)
Perform more complex requests (Sub-Queries)
Apply basic database security (Views, Users, Access)
Test that your SQL executes successfully and produces the expected results as this will be part of the
marking criteria.
Additional data may need to be added to fully demonstrate/test the query.
6
Include evidence that the SQL queries have executed successfully, using screenshots of
results/messages as appropriate, in the main report.
Include the SQL script as text in the appendices so that your marker can copy/paste/execute/test
the code in the relevant RDBMS.
Provide supporting explanation, assumptions and comments.
Evidence required:
A brief description of the five business requirements
Screenshots of the results/messages for each query
The SQL script (Include in Appendices as text) for each query
Any supporting explanation, assumptions, or comments
The suggested word count is 450 words
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|