NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level Introduction to Database Management System Assignment 11

Manufacturing
Consider the following relation that keeps track of the orders placed by a manufacturing
company:
Orders(orderDate, deliveryDate, supplier, partID, material, price).
Suppose the following functional dependencies hold on the relation:
orderDate, supplier -> deliveryDate
partID, supplier, orderDate -> price
partID -> material
material -> supplier.

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level Introduction to Database Management System Assignment 11

Manufacturing
Consider the following relation that keeps track of the orders placed by a manufacturing
company:
Orders(orderDate, deliveryDate, supplier, partID, material, price).
Suppose the following functional dependencies hold on the relation:
orderDate, supplier -> deliveryDate
partID, supplier, orderDate -> price
partID -> material
material -> supplier.

NIELIT A Level Introduction to Database Management System Assignment 10

NIELIT A Level

Introduction to Database Management System

Assignment 10

Wholesale Dealer

Consider the following relation that keeps track of the sales of a wholesale dealer in trousers:
TrousersSold(customerID, customerName, model, size, day, numberSold, price)
Suppose the following functional dependencies hold on the relation:

customerID -> customerName
customerID, model, size, day -> numberSold
model, size -> price
model, price -> size

NIELIT A Level Introduction to Database Management System Assignment 9

NIELIT A Level

Introduction to Database Management System

Assignment 9

Exam Administration
Consider the following relation that keeps track of the exams taken by students at
a University department:
Exam(studID, studName, courseID, courseTitle, acadYear,
examSession, mark, degreeCourse)