A hospital wishes to maintain database of all the doctors and thepatients in the hospital. For each doctor, the hospital is required to store thefollowing information:1. Name of the doctor2. ID of the doctor3. Telephone number of the octorAlso, for each patient, the hospitz is required to maintain the followinginformation:1. Name of the patient2. Ward number in which he patient is admitted3. Fees charged to the pat nt4. ID of the doctor who is treating the patientWrite a C++ program that will create necessary classes to store this data.

We need to create a simple hospital management system as per the given scenario.

A hospital wishes to maintain database of all the doctors and the patients in the hospital. For each doctor, the hospital is required to store the following information: 1. Name of the doctor 2. ID of the doctor 3. Telephone number of the octor Also, for each patient, the hospit is required to maintain the following information: 1. Name of the patient 2. Ward number in which he patient is admitted 3. Fees charged to the pat :nt 4. ID of the doctor who is treating the patient Write a C++ program that will create necessary classes to store this data.

A hospital wishes to maintain database of all the doctors and the patients in the hospital. For each doctor, the hospital is required to store the following information: 1. Name of the doctor 2. ID of the doctor 3. Telephone number of the octor Also, for each patient, the hospit is required to maintain the following information: 1. Name of the patient 2. Ward number in which he patient is admitted 3. Fees charged to the pat :nt 4. ID of the doctor who is treating the patient Write a C++ program that will create necessary classes to store this data.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN
An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.
One way to secure a database is to allow only administrators to have access to create and delete tables. (513)
as a database you need to ensure that each excercise log has a unique ID number, date, excercise category, excercise subcategory, time spent, calories burnt . each customer has unique cust_number and their first name, last name, address, program number, program tile and payment must be recorder. every program has a program number(PNum) that uniquely identifies the program. the program title, startDate, FinishDate, price must also be recorder. each coach has unique Id number. their first name, last name, date of birth, address, contactNo, username and password must be recorder. A coach can work on only one program. A program can have one or more coaches associate with it. one customer can enroll for one program at a time. normalize the above database in 3NF. State for every step in normalization which functional dependency cause it. identify different type of anomalies which can be found in a database. how can we overcome them ?
A database at a college must support the following requirements: a. For a department, store its number and name. b. For an advisor, store his or her number, last name, first name, and the department number to which the advisor is assigned. c. For a course, store its code and description (for example, DBA210, SQL Programming). d. For a student, store his or her number, first name, and last name. For each course the student takes, store the course code, course description, and grade earned. Also, store the number and name of the student's advisor. Assume that an advisor might advise any number of students but that each student has just one advisor. Design the database for the preceding set of requirements. Determine any functional dependencies. List the tables, columns, and relationships. In addition, represent your design with an E-R diagram.
True and falseLogical level is the physical level representation of database true and false mein bataiye
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.
Database systems In SQL MurachCollege database. Provide a list of all of the students, the number of courses they are taking, and the number of different instructors they have across all of their courses. The first column should provide the last name of each student (column titled Student Last Name). The second column should provide the number of courses that each student is taking (column titled Number of Courses). The third column should provide the number of different instructors that each student has for all of the courses they are taking (column titled Number of Different Instructors). No other columns should be provided in the result. Organize the result by student last name in alphabetical order.
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…
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