Tutor Quora

SIT772 Database And Information

Academic Anxiety?

Get an original paper within hours and nail the task

156 experts online

Free Samples

SIT772 Database And Information

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

SIT772 Database And Information

0 Download2 Pages / 455 Words

Course Code: SIT772
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Questions:

1. Explain the concept of data modelling and use Entity-Relationship (ER) models to represent data
2. Design and implement relational database systems through the use of SQL

Answer:

The elements of the table of this system based on the data problem statement are as follow

Student (Student_Id, Student_Name, Major)
Unit (Unit_Id, Unit_Title, Unit_Location, Instructor_Name)
Grade (Student_Id, Unit_Id, Grade)

1NF:
Based on the dependency diagram the only two field with no incoming arrows are Student_Id and Course_Id which are the prime attribute, so to normalize the data base to 1 NF we need to assign a primary key, as Course_Id and Student_Id satify the condition the primary key is a composite key of columns Student_Id and Course Id. (Riordan, 2005)
Student_Grade_Report (Student_Id, Student_Name, Major, Course_ID, Course_Title, Instructor_Name , Instructor_Location, Grade).
2NF:
To convert the given table from 1NF to 2NF we will need to remove all the partial dependency. The partial dependency exists when the non-prime attributes are dependent of part of the prime key.
The partial dependencies that exist are follow:

Student_Name and Major are partially dependent on the primary key (Student_Id,Course_Id) column Course_Id.
Course_Title, Instructor_Name,Instructor_Location are partially dependent on the primary key (Student_Id,Course_Id) column Course_Id.

So to remove partial dependency we create separate tables where the attributes are fully dependent of the primary key of that table.
Tables:
Students (Student_ID, Student_Name, Major)
Courses (Course_ID, Course_Title, Instructor_Name, Instructor_ Location)
Grades (Student_ID, Course_ID, Grade)
Student_ID and Course_ID are foreign keys.
3NF:
To convert the database from 2NF to 3NF we need to remove transitive dependency, transitive dependency is defined as the dependency in which the A->B and B->C so A-> is a transitive decency.
The transitive dependency is in the table Courses between the columns Instructor_Name and Instructor_Location. To remove this dependency a separate table is created with Instructor_Name and Instructor_Location.
Tables:
Students (Student_ID, Student_Name, Major)
Courses (Course_ID, Course_Title, Instructor_ID)
Instructor Id is the foreign Key
Grades (Student_ID, Course_ID, Grade)
Student_ID and Course_ID are foreign keys.
Instructors (Instructor_ID, Instructor_Name, Instructor_ Location) 
Exercise 2: Write SQL code to create the generated tables.
Students Table:
Query:
CREATE TABLE Students ( Student_Id INT NOT NULL , Student_Name VARCHAR(50) NOT NULL , Major VARCHAR(50) NOT NULL , PRIMARY KEY (Student_Id)) (SQL CREATE TABLE Statement, n.d.)
References
Earp, R. W., & Bagui , S. S. (2011). Database Design Using Entity-Relationship Diagrams (Foundations of Database Design). Auerbach Publications.
Riordan, R. M. (2005). Designing Effective Database Systems. Addison-Wesley Professional.
SQL CREATE TABLE Statement. (n.d.). Retrieved from W3SCHOOLS: https://www.w3schools.com/sql/sql_create_table.asp

Free Membership to World’s Largest Sample Bank

To View this & another 50000+ free samples. Please put
your valid email id.

E-mail

Yes, alert me for offers and important updates

Submit 

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.

UploadUnique Document

DocumentUnder Evaluation

Get Moneyinto Your Wallet

Total 2 pages

PAY 2 USD TO DOWNLOAD

*The content must not be available online or in our existing Database to qualify as
unique.

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

APA
MLA
Harvard
OSCOLA
Vancouver

My Assignment Help. (2021). Database And Information. Retrieved from https://myassignmenthelp.com/free-samples/sit772-database-and-information/foreign-keys.html.

“Database And Information.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/sit772-database-and-information/foreign-keys.html.

My Assignment Help (2021) Database And Information [Online]. Available from: https://myassignmenthelp.com/free-samples/sit772-database-and-information/foreign-keys.html[Accessed 18 December 2021].

My Assignment Help. ‘Database And Information’ (My Assignment Help, 2021) accessed 18 December 2021.

My Assignment Help. Database And Information [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/sit772-database-and-information/foreign-keys.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

Our specially curated generators have been revolutionary in helping the students cite resources (books, online articles, journals, websites, etc.). You have to visit our site and provide the details related to the resource. If you have Chicago referencing style requirements, Chicago reference generator will provide you with the final layout. Similarly, the Vancouver reference generator or Harvard reference generator will yield corresponding results. Thus, your issues with referencing style are permanently resolved. The reference generator related to APA is ideal for APA referencing assignments. Furthermore, you get the results instantly without you having to wait for delayed outputs.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next

Need an essay written specifically to meet your requirements?

Choose skilled experts on your subject and get an original paper within your deadline

156 experts online

Your time is important. Let us write you an essay from scratch

Tips and Tricks from our Blog

11174 Introduction To Management

Free Samples 11174 Introduction To Management .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} 11174 Introduction

Read More »