$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

COIT20247 Database Design And Development

tag 0 Download3 Pages / 570 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

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.

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 29 July 2021].

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 29 July 2021.

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


Need 24*7 available assignment help Melbourne? Get it from MyAssignmenthelp.com. We have a qualified team of assignment writers who are readily available to cater to your queries. We guarantee 100% customer satisfaction. Across the globe, we have more than 300k+ satisfied student-clients. Moreover, one can check what our customers have to say by going through the reviews. We post genuine reviews shared by real-time users.

Latest Database Samples

COIS 12036 Human Computer Interaction

Download : 0 | Pages : 4

Answer: Museum of Science and Technology outsourced development of a website to an IT firm. The purpose of the website was to showcase the items available in the museum and provide information about the facility including operating hours, location, and fees charged. After completing the previous project phases, we are now at the last stage of the project. This stage involves incorporating feedback provided in the last phases to refine the pro...

Read More arrow

COSC 1111 Data Communication And Net Centric Computing

Download : 0 | Pages : 6

Answer: 400 kbps channels Time slot 5 bits. Frame rate = Number of channels/time slot Channels = 400/5 =80kbps 80*100000=8000000 Frame rate= 8000000bps/5b= 1600000fps = 1600000fps Frame Duration = 1/1600000 = 0.000000625 seconds =0.625 ms c). MUX output bit rate = N*Maximum input Rate 5* 400=2000kbps 2000*1000= 2000000bps =2000000bps (i) Given Frame size =600 bytes Overhead =47 bytes ACK frame size= 78 bytes ? = Efficiency...

Read More arrow

COIT 20268 Responsive Web Design

Download : 0 | Pages : 5

Answer: The primary objective of the website it to provide an online platform through which Global toys can sell its products to target consumers. The website provides information about the shop and the products it sells. Individuals who visit the website can have a better understanding of the products offered in the shop. The website showcases a range of remote controlled toys, board games, and Lego models it sells. This is key in promoting t...

Read More arrow Tags: Australia Truganina Management University of New South Wales 

NIT1201 Introduction To Database Systems

Download : 1 | Pages : 6

Answer: Western Melbourne University consists of 7 colleges Arts, Science, Engineering, Business, Law, Education, and Information Technology.  The WMU Enrolment database is developed to store and maintain the information about the students enrolled in the college. The university intakes students during the month of February and July. All colleges provide both Bachelor and Master course. Most of the Bachelors take 3 years and master course...

Read More arrow

Z41000093 Big Data

Download : 0 | Pages : 15

Answer: Introduction  In case of Big Data analytics, HDFS is developed with the intention to store extensive amount of data dependably, and to transfer those informational indexes at a high bandwidth to client applications. As mentioned by Abdul, Alkathiri and Potdar (2016), for large cluster of servers, huge number of servers are attached to the data storage in order to faster execute client applications. By circulating the storage and ...

Read More arrow Tags: United States Wrexham Management Big Data Analytics University of Washington MBA 
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?