Dibatalkan

Draw an (ER) diagram & Draw a data modle

TASK 1 :

Draw an Entity-Relationship (ER) diagram for a General Hospital’s database using the following information.

1. The General Hospital consists of a number of specialized WARDS (such as Maternity, Pediatrics, Oncology, etc). Each ward has a name, code and hosts a number of patients.

2. On admission, the personal details of every PATIENT are recorded. These include ID, name, address, gender, birth date and illness. We also need to store the information of the tests undertaken by a patient and the results of a prescribed treatment. A number of tests may be conducted for each patient. Each patient is assigned to one leading consultant but may be examined by another doctor, if required.

3. Each patient also has a ATTENDANT. This person is a family member or friend who looks after the patient and takes responsibility for them.

4. DOCTORS have their own IDs and a specialization in some branch of medicine and there are three types of doctors – consultants, specialists and interns. Each intern is supervised by a specialist doctor. One doctor can act as a consultant for a several patients. Their patients can be admitted in a number of wards.

Clearly show primary key attributes.

-------------------------------------------------

TASK 2

1. Draw a data model - having at least four attributes - of an entity of your choice.

2. Using SQL in Oracle 10g,

a. Create a table for this entity and insert at least four rows of data.

b. Conduct Project and Restrict in a single query.

c. List rows in some given order.

d. Modify a row based on a given condition.

For each SQL task, you must show both the query and the output.

Kemahiran: Pentadbiran Pangkalan Data

Lihat lebih lanjut: diagram general hospital, draw diagram general hospital, draw diagram, modle, patient assigned leading consultant may examined doctor required, diagram general hospital consists number specialized wards, draw hospital, branch medicine, diagram primary, hospital consists number specialized wards maternity pediatrics, general hospital diagram, conduct project restrict single query oracle 10g, draw modle, given, draw data model, diagram data modle, draw entity relationship diagram oncology, draw diagram database, three d model, sql database consultant, sql consultants, sql code oracle, specialist doctor, specialist consultant, primary data

Tentang Majikan:
( 0 ulasan ) Jeddah, Saudi Arabia

ID Projek: #1583075

6 pekerja bebas membida secara purata $60 untuk pekerjaan ini

BZ3N5Lle8

Pls check PMB.

$50 USD dalam sehari
(0 Ulasan)
0.0
saikotju

Hi I have done such job as a part of database course...i can do it efficiently...thanks

$40 USD dalam 5 hari
(0 Ulasan)
0.0
ynufreeancer

Dear Fayrooz, I can help you with this. Have done some system design, including DB and process design. Please see my PM for my qualification. Looking forward to work with you.

$40 USD dalam 3 hari
(0 Ulasan)
0.0
saikatsarker

This is a simple project for me. You can have a look on the attachment.

$30 USD dalam 2 hari
(0 Ulasan)
0.0
HappyHome007

Hi, I am quite interested about your project. Basically I have a group of innovative web and database designers and developers. We all are freelancers. Recently we did some excellent jobs. I have put some of them i Lagi

$150 USD dalam 3 hari
(0 Ulasan)
0.0
sudarshana317

Hi Hiring manager, I am writing to express my keen interest in joining your team My core competencies include: 1> BO XI R3 admin,Universe and WEBI report design 2> Data Modelling 3> Oracle PL/SQL 4> Actua Lagi

$50 USD dalam 2 hari
(0 Ulasan)
0.0