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

Question:

a) 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. There is no need to show your working.
b) 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).

For your help, an example for a Student relation’s 3NF justification has been provided below: STUDENT (StudentID, Name, Address, DateOfBirth)
i. The primary key is StudentID which identifies a student. There will be one student name per Student ID because only one name is 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.

ii. The primary key is StudentID. This is the only candidate key since Name is not guaranteed to 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.
iii. Name cannot be used to functionally 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 normalform.

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 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.
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, 1 USD Per Page

Cite This Work

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

My Assignment Help. (2021). Database Design And Development. Retrieved from https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/duplication-issues.html.

My Assignment Help (2021) Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/duplication-issues.html
[Accessed 17 September 2021].

My Assignment Help. 'Database Design And Development' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/duplication-issues.html> accessed 17 September 2021.

My Assignment Help. Database Design And Development [Internet]. My Assignment Help. 2021 [cited 17 September 2021]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/duplication-issues.html.


Getting nightmare regarding pending chemistry assignment? Then it is high time you consider hiring chemistry assignment help service of MyAssigemnthelp.com. We at MyAssignmenthelp.com deliver quality subject specific assistance on more than 100+ subjects. For us, students' need is foremost, and we work round the clock to offer science, humanities and commerce assignment help. Among Commerce wing, our one of the most popular services is capital budgeting assignment help. In science segment, we have gained popularity with biology assignment help.

Latest Database Samples

ITC516 Data Mining And Visualisation For Business Intelligence

Download : 0 | Pages : 4

Answer: The PCA analysis for the given data on US utilities data has been carried out with the aid of XLMiner and the relevant matrix consisting of the applicable Eigen values has been presented in the output below. Result Analysis and Component Analysis One of the key requirements to analyze the above output is to decide the extent of variation that the researcher aims to explain. This is imperative since the significant principal component...

Read More arrow Tags: Australia Hawthorn Engineering University of New South Wales 

ITECH1006 Database Management Systems

Download : 0 | Pages : 6

Answer: Australian Premier League (APL) is about to implement a new system for managing the league. The system will have to run on a very effective database to avoid cases of redundancy in data. This document shows they system can be modelled by showing the entity relationship diagram and a set of normalized relations derived from the ERD. The ERD diagram for the new Australian premier league is shown below. The diagram shows all the entities...

Read More arrow

301044 Data Science

Download : 0 | Pages : 15

Answer: Introduction Cancer is among the health conditions that have emerged in the last two to three decades ago. It has been established that there is no definite cure for this condition. This has led to the development of more scientific research aimed at how medication or control procedures to this conditions can be developed. In this paper, breast cancer data obtained from kaggle.com is explored, inferential and regression statistical te...

Read More arrow Tags: Australia Melbourne Management University of Melbourne 

MIS 545 Data Mining For Business Intelligence

Download : 0 | Pages : 3

Answer: In the year 2017, an American restaurant named Chipotle was affected of a malware activity which hacked the payment site of the restaurant (Klein, 2017). The individual user who accessed the online portal of the restoration or used their debit and credit card in order to purchase food where the major victim of the attack. A confirmation was achieved that the malware which affected by the payment system was mainly installed at the point...

Read More arrow

COIT20248 Information Systems Analysis And Design

Download : 0 | Pages : 11

Answer: The report is prepared for Brisbane Multi Faith Temple for the development of the information to manage the donation of the temple and other activity of the temple. A project schedule and a cost benefit analysis is performed for analyzing the benefits. The resources are allocated to the project for the estimation of the cost and the details of the investigation techniques followed for the analysis of the requirement are given in the re...

Read More arrow
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?