$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 Download4 Pages / 806 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

1). Normalization
 
a). Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensurethat your relations meet 3NF. There is no need to show your
 
b). Select any two (2) of your relations from the previous step, 1a), and perform the following for each ofthose two relations:
 
List all the functional dependencies exist in the
 
Demonstrate that the relation meets Third Normal Form (3NF).

For your help, an example for a Student relation’s 3NF justification has been provided below:

STUDENT (StudentID, Name, Address, DateOfBirth)

1). The primary key is StudentID which identifies a student.  There will be one student name per Student ID because only one nameis recorded for each student. Even though a student may have multiple addresses (e.g. a home address and a work address), the case study states that there is a need to record the home address only and hence there will be only one address for each student. There will be only one date of birth for each student.  Thus, there are no repeating groups. Hence, this relation is in 1NF.

2). The primary key is StudentID.  This is the only candidate key since Name is not guaranteedto be unique (two different students may have the same name).  Address is also not guaranteed to be unique. This means that Student ID functionally determines every other attribute in the table.  There is a single valued simple candidate key (StudentId) and therefore no partial dependencies are possible.  Hence, the relation is in 2NF.

 3). Name cannot be used tofunctionally determine any other attribute in the table since two different students may have the same name; likewise for address and date of birth. Therefore there are no transitive dependencies in the table.  Therefore it meets the requirements of first, second and third normal 

2 Relational database implementation

Note: Use the relations that you created in the above step 1-Normalization to create a database. The recommended tool for this work is Microsoft Access, version 2010 or later. One reason for recommending Microsoft Access is that your unit lecturer/tutor will be able to provide adequate support to you in the use of this tool. If you choose to use a different DBMS, then there is no guarantee that your lecturer/tutor will be able to provide enough support to you.  The remainder of this document assumes that you are using MS-Access.

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 tableand 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 appropriaterelationships 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 theindexes follow the guidelines given in the unit 
  • Populate the database with sample data of your own. You must include sufficient sample data to testyour queries and report.  Please note that the expected result of query questions may depend on the actual sample data 

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/attributes-are-dependent-on-the-claimid.html
[Accessed 31 July 2021].

My Assignment Help. 'Database Design And Development' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/attributes-are-dependent-on-the-claimid.html> accessed 31 July 2021.

My Assignment Help. Database Design And Development [Internet]. My Assignment Help. 2020 [cited 31 July 2021]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/attributes-are-dependent-on-the-claimid.html.


With time, MyAssignmenthelp.com has become one of the best college essay writing services. Our all rounded services give students the confidence to overcome assignment related issues. Our services are fast enough to meet most urgent deadlines. We are capable of delivering fast essay writing services with the help of our specially designed provisions and writers' teams. Our urgent essay help services guarantee most rapid delivery of assignment solutions. Some of our most popular essay services are application essay help, exploratory essay help, literary review essay help and argumentative essay help.

Latest Management Samples

FIN200 Financial Accounting

Download : 0 | Pages : 10

Answers: 1. It is important to consider the fact that several factors are viewed by the tertiary sector staff members while deciding over the situation on placing the individual superannuation contribution that have certain benefit plan in along with the investment choice plan (Pratt 2013). On analysis, it has been found several issues that gets associated with the time value of money concept as it help in decision-making process in the most a...

Read More arrow

HLTH 1306 Health Practitioner Practice

Download : 0 | Pages : 4

Answers: 1. The following write up is my reflection on lectures, tutorials, policy, and readings about obesity, physical activity, and nutrition. This will involve identification and justifications of my ideas, beliefs, and values on obese population as they have been confirmed and others changed or challenged from the study. The write up will also contain my application of the information gained to my professional practice. Obesity has risen t...

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

COMP8440 Free And Open Source Software Development

Download : 0 | Pages : 2

Answer: The advancement in the technology has brought about changes in the structure of the software engineering. On the other hand, the development of the software, based on their specifications of open and closed source has made significant improvements in their structure. It has helped in the better understanding of the evolution and the modifications made. However, the reliability and the appropriateness of the modifications are determined...

Read More arrow

400210 Health Promotionn And The Nurse

Download : 0 | Pages : 14

Answer: Introduction Health promotion program is series of actions to encourage good health and wellbeing. Spreading consciousness about good health and wellbeing is a part of such promotional actions that includes enlightening people with the ways to stay fit and healthy. Promotion of practices and values that influences a community about good health is also a part of health promotional program (Eldredge et al., 2016). According to the Worl...

Read More arrow

BUSI2025 International Business

Download : 0 | Pages : 5

Answer: Introduction The purpose of this report is to identify various elements which are required to be concerned about at the time of designing a new accommodation hall for the students. There are few factors that are required to be taken care of at the time of planning and designing so that no loopholes exist in the designing process. The report will also help in offering various recommendations by which there can be effective arrangement ...

Read More arrow Tags: Australia Clontarf Management International Business University of New South Wales Masters in Business Administration 
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?