$$

Kingdom of Saudi Arabia

Ministry of Higher Education

Najran University

$$

$$

$$

Najran University

College of Computer Science and Information Systems

Course code : $380$ CSS$-3$

Main Project

Due date $15/10/1445$

Title: Hospital

In this project, you will use a Database Management System to create and manipulate a very small database system for a university Your task is to improve it to some extent and implement the design as well as some queries against it$.$ In this project, you will use any database server $($Oracle$)$

Project Description: You need to develop a management information system to help users at the administration level of the hospital easily viewing$/$tracking various information about doctor how many patient in department well as information about nurse $,$ room, department and lab.

Data Model $($Requirements $)$: We need to store information about hospital, each hospital has name $,$ unique hosp$\_$id and location, each hospital has many department $.$ Each department is describe by Dept$\_$no$,$ dept$\_$Name, phone and each doctor manages one department, the department include many nurse $.$each doctor identified by unique Doc$\_$ ID$,$name$($first$\_$name,last$\_$name $)$Phones$,$ address, email $,$salary and specialization $.$Each doctor works for one department. Each patient is described by unique paint$\_$no$,$ paint $\_$name, address, birthdate, age and phones. Each patient is assignee to one or more department and departments assigned many patients. It is required to keep track each admission date. Each doctors tridents many patient $.$each hospital has many room each room has room$\_$id$,$ and location, each nurse manages many room.each nurse has nur$\_$id$,$nurs$\_$name,salary $,$email.phone

Each lab is described by lab$\_$no and lab $\_$name. It is required to keep track the lab services. The patient has many service in lab and lab has many services to patient. Each doctor has many dependents and each dependents describe by name birthdate and sex

requirement: prepare the first phase of database design. conceptual design ER Model