$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

INFO6001 Database Management 1

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

Question:

Part A
Students are to create a database design specification (entity relationship diagram (ERD) and relational data model (RDM)) from the given business description below. Students are to present this in a report (as specified in the submission format) which also includes a short discussion of the approach for the solution. This assignment is to be carried out and reported individually.
The following defines the minimum information that should be reported:
1. A brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered
2. The Entity Relationship Diagram (ERD) (produced using a drawing tool such as those found in MS Word or PowerPoint, or a chosen CASE tool) for the system. Your ERD must use the ER notation that was taught in ICT701. Any assumptions made in creating the ERD must be explicitly stated in your report.
3. The Relational Data Model (RDM) which corresponds to the ERD. That is, the set of tables in 3rd normal form that could be used to represent the whole of this data model. Your RDM should identify primary, alternate and foreign keys.
Part B
Resolve the following relation to 3rd Normal Form. It is a requirement to show both the 1NF and 2NF that you found as part of the process in moving to 3NF.COMPACT_DISK(title number, album name, distributor id, distributor name,((track number, track name, track duration, ((artist id, artist name, date of birth, age, instrument_type, instrument description
Part C
Complete the following SQL tasks using MySQL. The marks available for each SQL task are indicated.
1) Write the SQL code that will create the table structure for a table named EMPLOYEE. The basic EMPLOYEE table structure is summarized in the table below.
3) Write the SQL code that will list all attributes for a job code of 502 in the EMPLOYEE Table.
4) Write the SQL code that will save the changes made to the EMPLOYEE table.
5) Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is 107. After you have completed the task, examine the results, and then by using SQL reset the job code to its original value. All SQL code to complete this full task must be shown in your submission.
6) Write the SQL code to create a copy of EMPLOYEE, naming the copy EMP_2. Then write the SQL code that will add the attributes and associated constraintsEMP_PCT and PROJ_NUM to its structure. The new attribute characteristics are:
EMP_PCT NUMBER(4,2)
PROJ_NUM CHAR(3)
7) Write the SQL code to change the EMP_PCT value to 3.85 for the person whose employee number (EMP_NUM) is 103. Next, write the SQL command sequences to change the EMP_PCT values as shown in the table below. .
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 4 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 Management 1. Retrieved from https://myassignmenthelp.com/free-samples/info6001-database-management-1/entity-relationship-diagram.html.

My Assignment Help (2021) Database Management 1 [Online]. Available from: https://myassignmenthelp.com/free-samples/info6001-database-management-1/entity-relationship-diagram.html
[Accessed 19 September 2021].

My Assignment Help. 'Database Management 1' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/info6001-database-management-1/entity-relationship-diagram.html> accessed 19 September 2021.

My Assignment Help. Database Management 1 [Internet]. My Assignment Help. 2021 [cited 19 September 2021]. Available from: https://myassignmenthelp.com/free-samples/info6001-database-management-1/entity-relationship-diagram.html.


Are you tired of getting negative comments repeatedly on your assignment in spite of working hard so much? If you are unable to understand where you are going wrong, it means you need professional assignment assistance. Signup with MyAssignmenthelp.com now to have top experts by your side. Our active chat support will not make you wait for long. They will assign the best writer in your subject who can solve your queries like assignment help Sydney.

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?