Nalanda Open University
Annual Examination 2016
Bachelor in Computer Application Part-II
Paper-XIV (RDBMS Lab) CS-67P
Time: 3.00 Hrs. Full Marks: 100(80+20)
Answer all questions. All questions carry equal marks.
1. A database system is to be designed to keep track of various bank accounts held by various
customers. A customer can have many accounts; also one account may be held by more
than one customer. Perform the following tasks:
Design and implement normalized relations/tables. You must include primary key,
validation checks and referential integrity constraints in relations/tables.
Enter about 5-6 sets of meaningful data in each table.
Design and implement the following queries/reports/forms for the database created by
you:
Create two forms — one for entering customer information and second for entering
account related information.
Find the list of those customers, whose total assets are more than 10,000.
List all those accounts which are opened in the last one year.
List the Cust_ID, Cust_name, Account_No and Balance for all the accounts.
Find the list of customers who have more than one account.
2. Define normalization? Explain the difference between BCNF and 4NF with an example.