For this lab we will be taking our various tables created from our normalization process and entering them into Oracle.

For each of your tables you will use SQL and the CREATE TABLE command to create each table with it's various attributes (columns).

You will then use the INSERT INTO command to add 5 rows of data (you make up your own data) to populate each table.

After creating the tables and entering the data - use the SELECT * FROM tablename to list all of the data in each table. You can do a screen capture to save the table data.

Turn in each "screen shot" of each of your tables with all of the data.

Please include screenshots of ORACLE

You will then use the INSERT INTO command to add 5 rows of data (you make up your own data) to populate each table.

After creating the tables and entering the data - use the SELECT * FROM tablename to list all of the data in each table. You can do a screen capture to save the table data.

you should have had at least 2 more tables....

PATIENT

BED

EMPLOYEE

DEPARTMENT

TREATMENT

TEST

Please include screenshots

ConSulbonl Businevw ton Sultont Employ se td cr) - Fint rame - stob - home hem Tech nical CanSul tant -Employee Td ( Last name Fint ram tast name -Technical Sk degvu neceive ^ tan in busin " Localion -Customer Ta - Location slreek . Location 4'LP. telephon -building st Companm c:1 Company strut company conlact telephon Contactno aestviplion attribu t or doh - amoun - Businem Consultan e Serv ConSulbonl Businevw ton Sultont Employ se td cr) - Fint rame - stob - home hem Tech nical CanSul tant -Employee Td ( Last name Fint ram tast name -Technical Sk degvu neceive ^ tan in busin " Localion -Customer Ta - Location slreek . Location 4'LP. telephon -building st Companm c:1 Company strut company conlact telephon Contactno aestviplion attribu t or doh - amoun - Businem Consultan e Serv