Choose three entities from the ERD that you develop, create three tables, and enter five rows of data into the tables. O

[correctanswer]

Choose three entities from the ERD that you develop, create
three tables, and
enter five rows of data into the tables. One of the tables should
have at least one
foreign key that is a primary key of one of the other two tables.
Capture the
screenshots of the table structure and rows of meaningful data and
put them in
the WORD document after the ERD. For instance, client name should
not be
‘aaaaaaa’ to satisfy the meaningful data requirement. Save the
commands that
you use to create tables and enter data into the tables in a SQL
script file. You
should include screenshots that show table structure and rows of
data similar to
the ones below in the WORD document after the ERD.
USING ORACLE SQL

Choose Three Entities From The Erd That You Develop Create Three Tables And Enter Five Rows Of Data Into The Tables O 1 (149.04 KiB) Viewed 89 times

Choose Three Entities From The Erd That You Develop Create Three Tables And Enter Five Rows Of Data Into The Tables O 2 (135.37 KiB) Viewed 89 times

PK employee ID First name Last name Email phone gender date of hire PK qualification testID Date Time FK tourlD Description FK employee ID PK tourlD Guides qualification test tour tour name approximate length fee charged categories Number Date Time Number Number text ====== Number Text Text Text Number Text Number Number Date Time Number Text Number H PK clientID PK locationsID name FK tourlD First name Last name phone gender Address FK outingID HPK outingID Date Time FK employee ID FK tourlD locations | type description client Number Text Text Text Number outing Number Text Text Number Text Text Number Number Date Time Number Number
Table structure: <Table name> COLUMN_NAME DATA TYPE ¹ HOTELNO 2 GUESTNO 3 DATE FROM CHAR (4 BYTE) CHAR (4 BYTE) DATE DATE VARCHAR2 (4 BYTE) *DATETO $ ROOMNO Data: <Table name> ( HOTELNO | GUESTNO () DATEPROM DATETO ROOMNO *H111 G111 26/12/03 2 H222 G111 03/06/04 05/06/041 29/12/031 H333 G112 06/06/04 10/06/041 *H111 G113 30/06/0401/07/043 sH1ll G114 05/07/0410/07/042 6 H111 G113 05/07/04 08/07/043 7H555 G116 01/08/04 03/08/04 2 *H111 G113 01/08/0408/08/043 *H111 G116 10/08/0414/08/043 w H111 G113 20/08/04 22/08/044 H444 G115 21/08/04 22/08/04 1 MALLABLE DATA_DEFAULT (null) (null) (null) (null) (null) No No No Yes Yes COLUMN_ID COMMENTS 1 (null) 2 (null) 3 (null) 4 (null) 5 (null)