[go: up one dir, main page]
Scribd
Upload
137 views5 pages

Database Assignment 2

The document discusses different types of database anomalies such as insertion, modification, and deletion anomalies. It provides examples of data stored in different normal forms, from first normal form to third normal form, with the data being normalized across multiple tables. The questions cover database concepts like normalization, anomalies, and transforming data from one normal form to another.

Uploaded by

NyoniTrinos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
137 views5 pages

Database Assignment 2

The document discusses different types of database anomalies such as insertion, modification, and deletion anomalies. It provides examples of data stored in different normal forms, from first normal form to third normal form, with the data being normalized across multiple tables. The questions cover database concepts like normalization, anomalies, and transforming data from one normal form to another.

Uploaded by

NyoniTrinos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Database Assignment 2

Question 1a)
i)An insertion anomaly is the inability to add data to the database due to the absence of other data.
There is missing data for record BITH01, row two of Database MySQL, BITH02 Programming
has got row missing data on five columns.
ii) (ii) Modification anomaly- An update anomaly is a data inconsistency that results from data
redundancy and a partial update. For example, each book in a department is associated with BookID
BookTitle, as well as the BookCategory.

iii) A deletion anomaly is the unintended loss of data due to the deletion of other data. For example,
if data is deleted from the first two rows of two records, The MySQL and Programming files will be
deleted as well.

b) First Normal Form


BookI BookTile BookCatego PublisherI PublisherNa CourseI CourseNa OrderCo
D ry D me D me py
BITH0 Database Technology Z101 Zambuko T113 Oracle 100
1

BITH0 Database Technology Z101 Zambuko M204 MySql 120


1
BITH0 Programmin Technology Z101 Zambuko T114 Visual Prog 40
2 g

BITH0 Programmin Technology ZOU Zambuko WB09 Web Prog 33


2 g
BITH0 Cloud Online Proc TZ020 Rose Pub C020 Cloud 27
3 Service Comp
BITH0 Cloud Online Proc TZ020 Rose Pub C020 Cloud 27
3 Service Comp
BITH1 Quality Business TC010 Gramsol K02 Soft Testing NULL
5 Assur
Second Normal Form

BookID BookTile BookCatego PublisherI PublisherNa


ry D me
BITH01 Database Technology Z101 Zambuko

BITH01 Database Technology Z101 Zambuko

BITH02 Programmin Technology Z101 Zambuko


g

BITH02 Programmin Technology ZOU Zambuko


g
BITH03 Cloud Online Proc TZ020 Rose Pub
Service
BITH03 Cloud Online Proc TZ020 Rose Pub
Service
BITH15 Quality Business TC010 Gramsol
Assur

Course CourseNa OrderCo


ID me py
T113 Oracle 100

M204 MySql 120

T114 Visual 40
Prog
WB09 Web Prog 33
C020 Cloud 27
Comp
C020 Cloud 27
Comp
K02 Soft
Testing

Third Normal Form


Book_Table
BookI BookTile BookCatego
D ry
Database Technology
BITH0
1

BITH0 Database Technology


1
BITH0 Programmin Technology
2 g

BITH0 Programmin Technology


2 g
BITH0 Cloud Online Proc
3 Service
BITH0 Cloud Online Proc
3 Service
BITH1 Quality Business
5 Assur

Publisher_Table
Publisher PublisherNa
ID me
Z101 Zambuko

Z101 Zambuko

Z101 Zambuko

ZOU Zambuko

TZ020 Rose Pub

TZ020 Rose Pub

TC010 Gramsol

Course_Table

CourseID CourseNam
e
T113 Oracle

M204 MySql

T114 Visual Prog

WB09 Web Prog

C020 Cloud Comp

C020 Cloud Comp

K02 Soft Testing

Order_Table
OrderCopy
100

120

40

33

27

27
NULL

Question 2

You might also like