Normalisation of a database schema assessment

Assignment Help Database Management System

Reference no: EM133749132

Database Design and Management

Assessment - Normalisation of a Database Schema

Your Task
This assessment is to be completed individually. You will use ChatGPT (free version) to generate an initial table for a database schema and a corresponding scenario. You will then use ChatGPT (free version) to analyse the schema, identify the dependencies, and normalise the schema step-by-step through the first normal form (1NF), the second normal form (2NF), and the third normal form (3NF).

Assessment Description

This assessment evaluates your understanding and application of database normalisation principles. You will transform an unnormalised database schema into its highest normalised form, typically the third normal form (3NF). You will use ChatGPT (free version) to generate an initial table for a database schema and a corresponding scenario. Your task involves analysing the schema, identifying dependencies, and normalising the schema while documenting your process. You will also create dependency diagrams for each table at each normalisation stage.

Learning outcome 1: Construct database models.
Learning outcome 2: Use normalisation techniques for the purpose of data integrity.

Assessment Instructions

To normalise a database schema from its initial unnormalised state to the third normal form (3NF) and document each process step, including dependency diagrams.Steps to Follow:

Use ChatGPT (free version) to create an unnormalised table for a database schema and a scenario that describes the database's context and purpose.

Example Prompt for ChatGPT:

"Generate an unnormalised table for a database schema related to a University Course management system and a scenario describing its use. The suggested database should include at least eight attributes."

Carefully examine the generated table and scenario to understand the structure and the data stored in the database.

List all functional dependencies in the unnormalised schema (the original table).

Transform to the first normal form (1NF) and ensure the table complies with the first normal form (1NF) rules. Draw the dependency diagram for the table in 1NF.

Transform to the second normal form (2NF) and draw the dependency diagram for the table(s) in 2NF.

Transform to the third normal form (3NF) and draw the table(s) dependency diagram in 3NF.

Document the final set of tables, including table names, attributes, and primary and foreign keys.

Provide a step-by-step explanation of how you transformed the schema from its initial form to 1NF, then to 2NF, and finally to 3NF.
Compile your analysis, normalisation steps, and dependency diagrams into a single document.

Reference no: EM133749132

Questions Cloud

Formulate business decisions within a global context : Critically appraise how organisations operate and apply these frameworks in a global perspective - In an effort to simulate a professional presentation

Presents requesting contraception : Chief complaint: A 25 year old female presents requesting contraception. She would like to discuss her options.

How social determinants of mental health impact : Discuss how social determinants of mental health impact on the mental health of a particular population or community group of your choosing.

What were three significant challenges with the response : HCAD 670- What were three significant challenges with the response? What were three ways in which the response could have been improved?

Normalisation of a database schema assessment : Construct database models and Use normalisation techniques for the purpose of data integrity - Normalisation of a Database Schema Assessment

Complaint of having acute left knee pain : Cyrus Horton. Patient C.H. is a 57-year-old male who presents to the outpatient clinic with a chief complaint of having acute left knee pain

Critical indicators of disease severity and prognosis : In a study of patients with heart failure, serum sodium levels are critical indicators of disease severity and prognosis.

How will you communicate and carry out the interventions : How will you communicate and carry out the interventions? What is the potential for resistance to change for each intervention, and how will you address it?

Brute force attack on wordpress website report : Brute Force Attack on Wordpress Website Report - you will submit report with clear screen shots and brief discussion of 'how to avoid Brute force attacks

User Account

All Pages