Implement the normalization process on unstructured tables

Assignment Help Database Management System

Reference no: EM133822139 , Length: word count:1500

Database Fundamentals

Introduction

For this assignment, you will need to implement the normalization process on unstructured tables provided. Book Our Writers Now!

Activity 1: Normalisation
Create a relational schema and demonstrate the First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF) for the provided tables. When breaking down composite attributes like ‘full name,' make sure to select suitable attribute names, such as dividing it into ‘firstname' and ‘lastname.'

S/No	Name	Address	Course Title 1	Course Title 2	Grade	Grade	Teacher 1	Teacher C	Teacher 2	Teacher C	Faculty
1	Alan N	1 Rock Rd, Glen	Computer Science	English	A	B	Mr NG	N	Ms ONG	O	Science/ Language
2	Janes C	12 Hardy St,Kin	English	High Math	C	A	Ms ONG	O	Miss WEI	W	Language/ Math
3	Kong Kong	1a Doggy Ave,	Low Math		A		Miss WEI	W			Math
4	Leo Long	9St John St,	History		B		MrSIM	S			Humanity
5	Bonnie Smith	3 Ring Rd	Account		C		Mr JIN	J			Commerce

Activity 2: Normalisation
Create a relational schema and demonstrate the Third Normal Form (3NF) for the database and table design you had created in your first assignment. When breaking down composite attributes like ‘full name,' make sure to select suitable attribute names, such as dividing it into ‘firstname' and ‘lastname.'

The format structure for the report
You are required to follow the following structure for this assessment. Below is the description for the report:
Introduction
Task 1
Task 2
Conclusion

Reference no: EM133822139

Questions Cloud

How dei benefits any healthcare workforce sector of choice : Develop a 10 to 12 pages PowerPoint presentation on how DEI benefits any healthcare workforce sector of your choice.

What considerations might you need to contemplate : What considerations might you need to contemplate when choosing the intensity an activity for an adolescent counseling or therapy group?

Write sql queries to create the table : Construct a database, execute CRUD operations within the SQL database, and engage in a discussion concerning data security concerns

Explain advantages for each specific data collection source : Explain the advantages and disadvantages for each specific data collection source by using examples and citing cases from the resource link provided above.

Implement the normalization process on unstructured tables : Implement the normalization process on unstructured tables - Create a relational schema and demonstrate the First Normal Form (1NF), Second Normal Form (2NF)

Compute the ending inventory and cogs at september thirty : Compute the ending inventory and COGS at September 30 on each of the following on periodic bases. Explain the above with numerical examples.

What is the etiology of the selected sti : What is the pathophysiology of one STI? What is the etiology of the selected STI? What are the clinical manifestations of the selected STI?

What is a scalable clustering algorithm : What are the characteristics of data? What is a scalable clustering algorithm? How do you choose the right algorithm?

Create an er diagram based on the case study : ITDA1001 Database Fundamentals, Victorian Institute of Technology - create an ER diagram based on the case study given and construct a written specification

User Account

All Pages