Scribd
Upload
9 views1 page

Database Management System Assignment 2024

This document is an assignment for the Database Management System course at ABES Engineering College for the 2024-25 session. It includes questions related to normal forms, functional dependencies, decomposition, and minimum cover of functional dependencies. The assignment is due on December 2, 2024, and consists of various tasks related to relational schemas and their properties.

Uploaded by

sanayasumpir
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

Database Management System Assignment 2024

This document is an assignment for the Database Management System course at ABES Engineering College for the 2024-25 session. It includes questions related to normal forms, functional dependencies, decomposition, and minimum cover of functional dependencies. The assignment is due on December 2, 2024, and consists of various tasks related to relational schemas and their properties.

Uploaded by

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

ABES Engineering College, Ghaziabad

Department of Computer Science & Engineering-Data Science

Session: 2024-25 Semester: V Section: C


Subject Code: BCS501 Subject Name: Database Management System

ASSIGNMENT NO. 3

Date of Assignment:21-11-2024 Date of submission: 02-12-2024

[Link]. CO Question Marks

Define normal forms. List the definition of first, second and third
1. CO3 4
normal forms. Explain BCNF with a suitable example.
Consider Relational Schema R(A,B,C,D,E,F,G,H,I,J) and set of
2. CO3 Functional Dependencies: F={AB->C,A->DE,B->F,F->GH,D->IJ} 4
Determine keys and decompose R into 2NF.
Given the following set of FDs on schema R (V,W,X,Y,Z) {Z→V,
W→Y, XY→Z, V→WX}State whether the following decomposition
3. CO3 are loss-less-join decompositions or not. 4
(i) R1=(V,W,X) , R2=(V,Y,Z)
(ii) (ii) R1=(V,W,X), R2=(X,Y,Z)
A set of FDs for the relation R{A, B, C, D, E, F} is AB →C, C →
4. CO3 A, BC → D,ACD → B, BE → C, EC → FA, CF → BD, D→ E. 4
Find a minimum cover forth is set of FDs.
a) Consider the following two steps of functional dependencies
F = {A → C, AC → D, E → AD, E → H} and G = {A → CD,
5. CO3 E → AH}. Check whether or not they are equivalent. 4
b) Define MVD & JD in detail.

You might also like