bcsl-034 solved assignment 2015-16 _ignouassignmentpdf.blogspot.com-2

7/25/2019 BCSL-034 Solved Assignment 2015-16 _ignouassignmentpdf.blogspot.com-2

1/12

Course Code : BCSL-034

Title : DBMS Lab

Assignment Number : BCA(III)/L-034/Assignment/2015

Maximum Marks : 50 Weightage : 25%

Last Dates for Submission : 15th October, 2015 (For July 2015 Session) 15th

April, 2016 (For January 2016 Session)

This assignment has only one question. Answer the question. This question

carries 40 marks. Rest 10 marks are for viva voce. You may use illustrations and

diagrams to enhance the explanation. Please go through the guidelines

regarding the assignments given in the programme guide for the format of

presentation.


2/12

1. A Stationery Retail Shop requires a computerized system to automize its inventory and billing

operations that support the following functionalities:

Easy input facility for new arr

available, Prices of various items, stock, etc..

Perform the following tasks:

(i)

Draw the ER diagram by identifying the entities, relationships and cardinality by using any

of the drawing tools like smartdraw, dia, visio, conceptdraw etc.. perform the above said

activities. Follow proper conventions.

Here we are creating Entity Relationship Diagram the Dental Clinic System:


3/12

(ii)

Create suitable database to support/accommodate all the functionalities referred above.

Perform Normalization till required NF and prepare Normalized tables.

(iii) Solution:

(iv) This is the most important part of every application in which the data of the

operations are stored in the related task in normal form. In our project we alsodefine some task, which is commonly created in the database. There are

following data structures.

(v) Table Name:-Registration Table

Field Name Description Type Size

Reg_no Patients Reg. No. Varchar2 10

Reg_fee Fee Number 8

P_name Patient Name Varchar2 30

G_name Guardian Varchar2 30

Age D.O.B. Date 5

Weight Weight Varchar2 40

Address Address Varchar2 10

(vi) Doctor Table


Doc_id Doctor id Varchar2 10

Doc_name Doctor name Varchar2 30

Phone Phone Number Number 10

Specialist Specialist Varchar2 10

Availability Attendance Varchar2 2

(vii) Payment Table


Reg_no Patient Reg. No. Varchar2 10


4/12

P_name Patient Name Varchar2 30

Room_no Room/Bed Varchar2 10

Operation_fee Operation Fee Number 10

Total Total Varchar2 5

Pay Payment Varchar2 5

(iii) Using MS-Access, design various forms to support the operations such as enquiry

form, details about new arrivals, stock update, discount details, bill generation, staff

details, frequent visitors customers list etc..

Solution:

First we have to create a table to store important details of doctors as per required

according to the question.

Here we have created a table named Doctors Record which we will use in the forms so

created


5/12

Creating Enquiry Form using the Form Design Tool. Here we have created a form for the

enquiry purpose of a dental clinic.

Details of visitors are entered and stored in the database using this form


6/12

Creating Registration form for the patients so admitted.

Here we are entering and storing the details of patient who are being admitted in the

hospital.


7/12

Here is the list of services and facilities provided in the dental clinic.

Patient can acknowledge the charges for different services provided and can select one and

proceed.


8/12

Details of doctors are pr(iv) Report generation like daily reports, list of complaints / rejection

of items (if any), staff attendance etc..ovided under this form
http://ignou.nisecomputers.com/bca-bcsl-034-solved-assignment-2014-2015/list_of_services/


9/12

(iv) Report generation like daily reports, list of complaints / rejection of items (if any),

staff attendance etc..

Solution:

Following report generated on the basis of visitor consolation.
http://ignou.nisecomputers.com/bca-bcsl-034-solved-assignment-2014-2015/list_of_doctors-2/


10/12

Report generated on the basis of complains against faulty equipment
http://ignou.nisecomputers.com/bca-bcsl-034-solved-assignment-2014-2015/report-generated/


11/12

Report generated on the basis of staff attendance
http://ignou.nisecomputers.com/wp-content/uploads/2015/01/STAFF-ATTENDNS-REPORTS.bmphttp://ignou.nisecomputers.com/wp-content/uploads/2015/01/compliant-report1.bmp


12/12

bcsl-034 solved assignment 2015-16 _ignouassignmentpdf.blogspot.com-2

Documents