Its database class

We choose the topic Hospital Management

read phase $1$ and then answer$/$fill the paper

The role of a database architect is to gather the key data points of an organization to plan the proper database structure to

facilitate that data. Your task here is to gather the data requirements for an organization $($real or made up$)$ of which pertains

to your interest. Some examples include: books, movies, music, computer games, geographical locations, genomic sequences,

flights, etc. The only exception to this would be the University database that we have been using throughout the semester.

For this phase, your task is to create a document that details the business case of the project, your assumptions, and the

scope of the project. You must state the business case, its entities, the requirements that are need by the different roles of

the users, and finally the constraints of each entity and its attributes. You may state any assumptions you want, but your

design must reflect those assumptions.

Scope and Complexity

$1.$ The detailed description of your application must include some of the functionalities that the application will support.

$2.$ Your application must be relatively substantial with at least $6$ entities or more.

$3.$ There must exist more than $3$ foreign key relations in the database.

$4.$ Primary keys must be clearly defined, including at least one relation with a composite primary key

$5.$ All attributes must be reflective of the relation that it resides in$.$ For example: A student entity has a first and last

name, a student id$,$ an email, an address, a phone number, etc. Things that are not part of the student should not be

in the student entity, such as class name which would belong in a class table.

Requirements

$1.$ A detailed description of the project that will include the Business case, the scope of the application, the users of the

application, the expected functionalities of the application for each user, and finally the relationships that need to be

addressed in the database to meet the business needs of the users. There shall be at the very least $3$ users and at

least $3$ needs or interface per user, depending on their roles, this can be less or more.

$2.$ A list of at least $6$ entities that cover the breadth of the organization.

$3.$ For each entity propose a draft of their attributes, including the candidate keys that will be primary keys, use the

relational schema notation for this. The schema For the University database

classroom$($building$,$ room$\_$number, capacity$)$

department$($dept$\_$name, building, budget$)$

course$($course$\_$id$,$ title, dept$\_$name, credits$)$

instructor$($ID$,$ name, deptname, salary$)$

section$($course$\_$id$,$ sec$\_$id$,$ semester, year, building, room$\_$number, time$\_$slot$\_$id$)$

teaches$($ID$,$ course$\_$jd$,$ sec$\_$jd$,$ semester, year$)$

student$($ID$,$ name, dept$\_$name, tot$\_$cred$)$

takes$($ID$,$ course$\_$id$,$ sec$\_$id$,$ semester, year, grade$)$

advisor$($s$\_$ID$,$ i$\_$ID$)$

time$\_$slot$($time$\_$slot$\_$id$,$ day, start$\_$time, end$\_$time$)$

prereq$($course$\_$id$,$ prereq$\_$id$)$

Please its Database not python class...