Step 8: Basic Mapping Transform the HealthOne database entities into table diagrams - use suitable naming...

Transcribed Image Text:

Step 8: Basic Mapping Transform the HealthOne database entities into table diagrams - use suitable naming conventions. Transform relationships into foreign-key columns. Transform the Visit supertype entity using the single-table implementation. Using the following table diagrams, include as many rows as necessary: Key Type (pk, fk) Optionality ("*" or o) Column name Step 9: Creating database Develop SQL code that would create the database files corresponding to your relational schema for the HealthOne Medical Database project. Write the SQL statements for creating the tables, specifying data types and field lengths, establishing primary keys and foreign keys, and implementing other constraints you identified. Write the SQL statements that create the indexes. This is optional. You should execute your SQL code on a DBMS (Oracle 12c) to test its correctness and gain the hands-on experience, which is one of the main objectives of this project. Step 8: Basic Mapping Transform the HealthOne database entities into table diagrams - use suitable naming conventions. Transform relationships into foreign-key columns. Transform the Visit supertype entity using the single-table implementation. Using the following table diagrams, include as many rows as necessary: Key Type (pk, fk) Optionality ("*" or o) Column name Step 9: Creating database Develop SQL code that would create the database files corresponding to your relational schema for the HealthOne Medical Database project. Write the SQL statements for creating the tables, specifying data types and field lengths, establishing primary keys and foreign keys, and implementing other constraints you identified. Write the SQL statements that create the indexes. This is optional. You should execute your SQL code on a DBMS (Oracle 12c) to test its correctness and gain the hands-on experience, which is one of the main objectives of this project.