This organization provides following functionalities• Emergency Care 24x7• Support Groups• Support and Help Through callsAny new Patient is first registered in their database before meeting the doctor. Each Doctor haveID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctorcan update the data related to the patient upon diagnosis (Including the disease diagnosed andprescription).doctor examined number of patients on daily bases. Patient has unique id, name,age, gender, disease status (admitted, discharged, expired), date and address.Patients with criticalcondition are examined by many doctors. This organization also provides rooms facility foradmitting the patient who is critical. One room can be booked by one patient only and each roomhas room#, location attributes. Rooms are distributed among two categories general and VIP.Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy isassigned to no of doctor. Nurse and ward boys table can store name, age, gender, and addressand skills. Also, they can be assigned to patients (to take care of them). One nurse can beassigned to no. of patients. The bill is paid by the patient with cash and E-banking. Record ofeach payment made is also maintained by the organization. Payment record saves amountpayable, date and status of payment pending or paid. The record of each call received to providehelp and support to its existing person is also maintained. Each doctor's record is maintained byorganization and no of patient examined by a doctor can be calculated. Organization also keepsrecord of expiries and no of expired patients can be calculated.Q1. Create database name as “health facilitator" in SQL server.Q2. Create table in SQL with proper metadata. Take screenshot and paste on word file.Q3. Insert 10 records in each table and take screenshot and paste on word file.

Answered: Image /qna-images/answer/559cb9a0-bd7e-440a-8b52-7710e5e47b85.jpg

This organization provides following functionalities • Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address.Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical One room can be booked by one patient only and each room

This organization provides following functionalities • Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address.Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical One room can be booked by one patient only and each room

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Database Management Systems (SQL) Assume a company sells music albums. Each album consists of a few songs from a single artist. The tables used by this company are as follow: Artist: (The attributes describing an artist) Song: (the attributes of a song, includes a foreign key to Album) Album: (includes attributes of the album. Also includes a foreign key referring to Artist) Write necessary SQL commands to create the tables. Add necessary constraints including primary key, foreign key, not null, unique, etc. Write necessary SQL commands to add a few records to each table Query the database: 1. Find all albums belonging to an artist given his/her name 2. Given the name of a song, find the album name and the artist 3. Find out how many songs have been included in an album given the album name 4. Find out the total number of songs of an artist given his/her name 5. Add an attribute to the song table named genre. Update the values of all records giving meaningful genre attribute values to…
Design your application's/organization's database. You need to create the 3 tables for each of the services offered. You must provide at least 5 examples in each of the table. There must be a table in which you have prices linked to the services you are providing. THIS IS THE NAME & DESCRIPTION OF THE ORGANIZATION FOR WHICH YOU NEED TO CREATE 3 TABLES FOR EACH SERVICE PROVIDED *Name of the Organization* :: ECOHUB *Description of the Organization* :: EcoHub is a sustainability-focused organisation that seeks to encourage environmentally friendly behaviours, increase public knowledge of environmental problems, and offer solutions for people, organisations, and communities to reduce their carbon footprint and help make the world a greener place. We think that many little individual actions can have a big influence on the environment when taken together. *Services Offered by the Organization are*1. EcoConsultancy : We provide individualised eco-consultancy services to people and…
SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years. 3. Find the names of buildings where more than 50 employees work. 4. The tables have…
Using the database schema attached, write SQL query for these statements: (1) List stores with more than 200 customers. (2) Display the average amount paid by each customer, along with the customer's first and last name.
SQL BITS List client number, balance, consultant number, and consultant last name of every client whose balance is greater than that of client number '405.'
Identify opportunities for using triggers in your database and write the appropriate DDL queries for them
The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.
How are keywords used in SQL queries to retrieve specific data from a database?
A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number • Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale The average price of a computer was sold by the retailer In which months less than 100 computers were sold
SQL Use the IN operator to list the item ID and description of each item in category FSH or BRD.