NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level

Introduction to Database Management System

Assignment 5

Assume that a Consumer item lease Company which leases various household items to its clients for their use for a specific period of time, maintains the following tables:

Clients (clientID, name, address, contact Phone)

Itemlist (itemID, itemName, itemCost, purchase Date )

Leaselist (clientID, transactionNO, itemID, startDate, returnDate, amountTObeCharged)

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level

Introduction to Database Management System

Assignment 4

Consider the following requirements for a construction company that uses database system to keep track of its projects, workers and material requirements of various projects.

The projects for the company are of two kinds: (i) Turn key projects and (ii) Others.All the projects have a life cycle (Please note that the turn key projects have a maintenance phase in addition.) and workers are allotted as per the phase of the project. Each project has its own plan of completion that is drawn at the start of the project. The worker and material requirement of project is calculated at the start of the project.

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level

Introduction to Database Management System

Assignment 3

Performa following queries in SQL using the above schema:
a) Find details of Teachers who taught DBMS.
b) Find details of students who did MCA from PB University.
c) Find courses taught by T# 5078.

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level

Introduction to Database Management System

Assignment 2

Create an E R diagram and relational schema to hold information about the situation inmany institutions affiliated to some University, many teachers of different disciplines areteaching to many students enrolled in many courses offered by the university to thestudents through the institutions. Use concept of keys, aggregation, generalisation,cardinality etc. in a proper way.Say the schema of respective entities is:Teacher( T#, Tname, Tqual, Tsubject, Tcourse, Prog)