We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: [email protected] after completing this order process.
No Plagiarism Guarantee - 100% Custom Written
Here, you are required to present a report covering all these aspects:
Assessment task
1 Normalization
For your help, anexample for a Student relation’s 3NF justification has been provided below:
2 Relational databaseimplementation
In implementing the ER model provided, you must complete the followingtasks:
Dataintegrity
You are required to implement integrity constraints within the database to enforce thefollowing requirements:
Informationrequests
Create queries to answer the following information requests. Note: Do not use the Access querybuilder (QBE) to create your queries – you should type the queries manually using SQLview/editor.
Themarking process of the queries for information requests may also consider the effectivenessofyourSQL statements that have been used in the queries.ItisimportantthatyourSQLstatementmustreflectthe correct business logic & SQLsyntax.(Use enoughsampledataso that the output is produced by each and every query).
ImplementationReport
You must also provide a short implementation report describing your experiences with thisassignment. You may discuss any of thefollowing:
Use the implementation report to demonstrate that you have thought carefully about the issues thatarise when implementing a relationaldatabase.
What you shouldsubmit
Microsoft Access databases filecontaining:
A Microsoft Word documentcontaining:
Your document should contain appropriate identification information (your student number, name,unit number, etc.) and should contain the relevant headings for eachsection.
Importantpoints
Assessmentcriteria
COIT20247 Assignment 2 Marking Sheet
1
Relational database implementation (12 marks)
Available marks
Set of relations correctly mapped from ERD
3
Functional dependencies correctly listed for two of the relations
2
Normalization correctly listed for two of the relations
Relationships set up correctly, referential integrity enforced, appropriate use of cascade update/delete
Data types & sizes selected appropriately
Indexes – Indexes are appropriate
Data integrity (3 marks)
Data integrity correctly implemented
Queries (12 marks)
Query 1
Query 2
Query 3
Query 4
Query 5
Query 6
4
Report (4 marks)
Underlying query/queries has/have been created and are correct
Report layout and heading are appropriate; grouping and sorting are appropriate
5
Implementation report (4 marks)
Implementation report discusses appropriate issues
Sub-total before any possible deductions
35
Late penalty (enter as the number of days late)
Assignment 2 total
/35