BoardGuess.com

IGNOU BCA Sem-4 Assignment (CS-67 : RDBMS Lab)

CS-67 :           RDBMS Lab

Assignment code     :           BCA (4)-66/Assignment/ 2009

Maximum Marks                  :           25

Last Date of Submission       :           30th April, 2009/30th October, 2009

There are two questions in this assignment. Answer all the questions. You may use examples illustrations or diagrams to support your answer. You have to implement the database system using any RDBMS.

Q. 1    A Pharmacy company keeps track of its product, customers and raw material suppliers using a database management system. The company produces two basic types of products – products for general medical purposes and products that can not be sold without prescriptions. The customers of the Pharmacy may be individuals or other companies. Perform the following activities for the company:

(a)    Make an ER-diagram for the company, stating assumptions if any. You may use the concept of keys, aggregation, generalisation, cardinality etc. in a proper way.                            (2 marks)

(b)   Design the suitable RDBMS tables for the ER-diagram so created in part (a). The database design should include keys, foreign keys, constraints and referential integrity constraints.                                                                                (2 marks)

(c)    Implement the database design that you have created in (b) using a RDBMS – our advice is that you choose either MySQL or MS ACCESS to do so.         (2 marks)

(d)   Create four data entry forms with suitable checks for the database so created.                                                                                                                           (2 marks)

(e)    Enter at least 4 sets of records in each table preferably using data entry form created in part (d)                               (2 marks)

(f)     Create four reports for the database you have created. The reports should have proper headings and page numbers and should include totals, if needed.                                                     (2 marks)

Download Attached PDF





Start Discussion!
*
* (Will not be published)
* (First time user can put any password, and use same password onwards)
*
Start a new topic: (If you have any question related to this post/category then you can start a new topic and people can participate by answering your question in a separate thread)
Title/Question: (55 Chars. Maximum)
Comment/Detailed description:* (No HTML / URL Allowed)

Characters left

Verification code:*



(If you cannot see the verification code, then refresh here)




CBSE Board, UP Board, IGNOU, JNU, MBA MCA, BBA and other educational boards of India

Disclaimer: For documents and information available on BoardGuess.com, we do not warrant or assume any legal liability or responsibility for the accuracy, completeness, or usefulness of any information. Papers, Results, Syllabus, Logo and other educational contents are owned by Indian Education Board and BoardGuess does not hold any copyright on it. The format of materials, being displayed on this website, comes under the copyright act. BoardGuess.com, All Rights Reserved ©