Create a database consisting of Name of Hospital, Number of Department

Question

Create a database consisting of Name of Hospital, Number of Departments, Number of Patients in each Department, Number of Patients who are discharged within a week’s time of their admission to Hospital. Make necessary assumption.

15 Sep 2022

Answer :

Word Count : 150

To create a MySQL database with the specifications you mentioned, you can use the following SQL code:

CREATE DATABASE HospitalDatabase;

USE HospitalDatabase;

CREATE TABLE Hospitals ______ __________ ___ _________ ______ _________ _____ __________ _______.
________ __________ _____ ______ __________.
____ ______ __________ _____ ______ ________ ____.
_____ ___ ______ ____ _______.
________ ________ _______ _____ __________ __________ ______ _________ ____ _____ ____.
__________ _____ ________ ___ ____ _______ __________ __________.
________ ______ ______ _______ ___ ______ ______ _______ ____ _____.
____ ________ ________ ________ ________ _______ ___ _____ _________ ___ ___.
__________ _______ ___ _________ ___.
__________ _________ ___ __________ ____ ________ _________ ___ ______ __________ ________ ___.
______ __________ _____ _________ ________ ______ ____.
_______ _________ _____ _____ _______ _________ _______.
___ ___ __________ _______ _______ ____ ______ ___ ______.
_________ _______ ______ ________ _______ ________ ______ __________ ____.
____ _____ __________ ___ _____ __________.
______ ________ __________ ______.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★