Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Performing Tables Normalisation in a PowerPoint Presentation

Task Instructions

In this assessment, you are required to perform database table normalisation and present your solutions in a PowerPoint presentation. In doing so, you are required to demonstrate your work and solution through a series of normal forms. You need to first normalise the database tables to the first normal form (1NF), then the second normal form (2NF), and finally the third normal form (3NF).

  1. Examine the following student table, which is used for a student record management system in an Australian university.

Attribute name

Sample value

Sample value

Sample value

STU_NAME (Primary

Rhys Pickering

Mandeep Kaur

Manpreet Singh

Xiao Zhang

Key)

STU_PHONENUMBER

0406465234, 03

0406475234, 03

0406467334, 03

0406469034, 03

9654 3316

9654 3336

9654 3318

9654 3319

STU_DOB

3/12/1997

4/8/1998

8/4/1997

5/6/2000

STU_HOMECOUNTRY

Australia

India

India

China

STU_CONTINENT

Oceania

Asia

Asia

STU_GENDER

Male

Female

Female

STU_SCHOOL

Business

IT and

IT and

Business

Engineering

Engineering

STU_MAJOR

Accounting

Software

Information

Finance

Development

Systems

SCHOOL_HEAD

Andrew Yue

Suzanne Pita

Suzanne Pita

Andrew Yue

SCHOOL_PHONE

9054 1321

9067 1835

9067 1835

9054 1321

STU_SUBJECT

Accounting

Introduction to

Introduction to

Introduction to

Principles,

Programming,

Programming,

Microeconomics,

Business Law,

Database

Introduction to

Principles of

Quantitative

Fundamentals

Information

Finance

Method

Systems

SUBJECT_LECTURER

James,

Andrew,

Andrew,

June,

Terry,

Peter

John

Fariza

Wei

SUBJECT_CODE

ACCT1001,

BIT1001,

BIT1001,

FINC1001,

BLAW1002,

BIT1002

BIT1003

FINC1002

QUAN1003

SUBJECT_CREDITPOINT

6,6,6

12, 6

12, 6

6, 6

STU_SUBJECTMARK

60, 70, 80

50, 60

70, 80

70, 70

STU_AVERAGEMARK

70

55

75

70

P, C, D 

P, P

C, D

C, C

STU_SUBJECTGRADE

 
  1. Please complete the following tasks and deliver a 5?minute presentation to communicate your answers/solutions to an audience.

Draw and present a dependency diagram for the table above, including transitive dependencies. In your oral presentation, you need to explain each dependency.

If the table above is not in the first normal form, normalise it so that it is in the first normal form without creating any more tables. You may create an additional attribute or attributes. Orally present your solution and the reason why it was not in the first normal form, and what changes were made to make it in the first normal form. If the table above is in the first normal form, explain why it is in first normal form.

If the resulting table from the previous task is not in the second normal form, normalise it so that it is in the second normal form without creating any more tables. You may create an additional attribute or attributes. Orally present your solution and the reason why it was not in the second normal form, as well as the changes that were made to turn it to the second normal form. If the resulting table from the previous task is already in the second normal form, explain why it is in the second normal form.

If the resulting table from the previous task is not in the third normal form, normalise it so that it is in the third normal form. You may create additional tables. Orally present your solution and the reason why it was not in the third normal form, as well as the changes that were made to turn it to the third normal form. If the resulting table from the previous task is already in the third normal form, explain why it is in the third normal form.

Based on the resulting table from the previous task, draw and present an ERD to the audience. Please use LucidChart or an equivalent professional diagramming software application to draw the ERD.

When completing this assessment, you are required to make reasonable assumptions based on common sense. For example, the following are considered as common sense or reasonable assumptions:

Two persons may have the same name, that is, the same first name AND same last name.

Two persons who were born on the same day may have the same name. A student will undertake more than one subject at a university.

More than one subject may be taught by one lecturer. Each subject has only one subject name.

Each School only has one Head of School.

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close