Search & Filtering
A hospital has Patient Appointment Management System (PAMS), in which all the details of doctors, patients and appointments are given. In this scenario all the details of appointment and patients are shared with the doctor and all the doctors have access to fix and cancel the appointments. Similarly, patients are also authorized to view the doctors list and appointments. Following are the key points of the functionality of PAMS:
⦁ According to the system, patients get the basic information of the doctor, specialization, charges per hour and work hour.
⦁ The system will allow doctors to add/delete and update the schedule.
⦁ The doctors must be able to maintain per visit charges.
.Q1. Construct an Entity Relationship Diagram (ERD) using the identified entities, attributes and mention the valid relationships and cardinality between them.
Explain triggers & stored procedures. Why do we use them?
Benefits of triggers & procedures. Syntaxes & example of them.
A hospital has Patient Appointment Management System (PAMS), in which all the details of doctors, patients and appointments are given. In this scenario all the details of appointment and patients are shared with the doctor and all the doctors have access to fix and cancel the appointments. Similarly, patients are also authorized to view the doctors list and appointments. Following are the key points of the functionality of PAMS:
⦁ According to the system, patients get the basic information of the doctor, specialization, charges per hour and work hour.
⦁ The system will allow doctors to add/delete and update the schedule.
⦁ The doctors must be able to maintain per visit charges.
Q1. You are required to identify the entities for the above scenario.
Q2. You are also required to identify the attributes of each entity which is already identified in the above Q1.
Suppose that you need to store information of ’Person’ having a multivalued attribute called ’hobby’. A person’s
hobbies can be reading, writing, gardening, soccer, cricket, movies, etc. At present, the database table Person
can store only one hobby! As a database programmer, what would you do to store these multi values f hobbies?
The Person table schema:
Person(id, name, position, hobby)
Consider the following scenario and normalize the database upto 3NF - [10]
Best-East University is currently in need of a software system for course registration. The university has
more than one department and each department has many courses of a particular program such as the Bach-
elor and Masters program. A student may register (enroll) all or subset of offered courses for a trimester (e.g.
Spring, Summer, Fall). During the registration period, a student’s registration is authorized (signed) by the
batch advisor. A batch advisor is a faculty member assigned to the batch. Once the registration date is over, a
student may late register courses with a late registration fee. In the case of late registration, a student requires
the signature of both the batch advisor as well as the department chairman’s authorization.
What is the process of creating, arranging and maintaining a system of information retrieval called?
Define Concurrency in Database management System?
What is Backup and Recovery in DBMS?
What is SQL Aggregate Functions Define with Examples
1.
Get the top 10 channels for which more number of users are subscribed in the year 2018.
Note:
In case, if the no_of_subscribers are same, then sort the output in the ascending order of channel_name.
Expected Output Format:
channel_id channel_name no_of_subscribers
#340153 on Dec 2023