New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

COIT20247 Database Design And Development

tag 0 Download 3 Pages / 570 Words tag 03-11-2020

Questions:

Assessment task

1. Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations meet 3NF.

2. Select any two (2) of your relations from the previous step, 1a), and perform the following for each of those two relations:
List all the functional dependencies exist in the relation.
Demonstrate that the relation meets Third Normal Form (3NF).

 

3. In implementing the ER model provided, you must complete the following tasks:

Create all the relations in a Microsoft Access database. Consider each attribute in every table and make appropriate choices regarding data types & sizes, indexes, required/not required and validation rules. Your choices should be appropriate for each attribute and should support data integrity. (Note: see the Data Integrity section below for specific data integrity requirements)

Create relationships as appropriate. Enforce referential integrity for all appropriate relationships in the database. Apply cascade update and/or delete options wherever necessary.

Review the default index created by Access for each table. You should ensure that the indexes follow the guidelines given in the unit textbook.

Populate the database with sample data of your own. You must include sufficient sample data to test your queries and report.  Please note that the expected result of query questions may depend on the actual sample data populated.

4. You are required to implement integrity constraints within the database to enforce the following requirements:

Insured amount should be positive currency and expressed in 2 decimals only.
Policy date should have appropriate date value.
Name of persons such as customer and assessor should not be null.
Each policy should be related to one property/home.

5. Create queries to answer the following information requests:

The marking process of the queries for information requests may also consider the effectiveness of your SQL statements that have been used in the queries. It is important that your SQL statement must reflect the correct business logic & SQL syntax. 

i. Display the number of policies issued/created for each category of policies.

ii. Display the details of assessor(s) who has/have never performed/completed any assessment report.

iii. Display the number of settled and rejected claims.

iv. Display the details of customer(s) whose claim(s) has/have been rejected.

v. Display the highest amount of the claim-settlement(s) that has/have been done.

vi. Display the total amount of premium paid for each of combined Home-buildings-contents policies.

Report

Create a simple report object showing the details of rejected claims.  The report should provide the details of claim, policy and property details in ascending order of claim date.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2020) Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/the-concept-of-the-normalization-process.html
[Accessed 13 August 2022].

My Assignment Help. 'Database Design And Development' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/the-concept-of-the-normalization-process.html> accessed 13 August 2022.

My Assignment Help. Database Design And Development [Internet]. My Assignment Help. 2020 [cited 13 August 2022]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/the-concept-of-the-normalization-process.html.


We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?