In this assignment you will create the physical database from your design created in Project 2.
Project 2 was a logical model of the Mom & Pop database. We need to transition the logical model into a physical implementation. As noted in the course content, a physical implementation is the database created on a system that we will use. To this end, we use SQL to create the database.
SQL is standard between many relational database types and is a part of Oracle, as noted in our readings this week. Also, SQL had a few different ‘subsets’ of language commands, which includes Data Definition Language (DDL) and Data Manipulation Language (DML), as two of the primary SQL language subsets .
To create the database in a database tool like Oracle, we use SQL’s Data Definition Language (DDL), which allows us to tell the database how the tables and the associated fields within the tables are described.
Step One: CREATE THE SQL DDL FOR YOUR DATABASE
For your logical database model created in Project 2, create the SQL DDL commands that will be submitted to Oracle. Oracle will create the data structures to hold your data.
EXAMPLE:
From our reading – Creating a table.
• Describe the layout of each table in the database.
• Use CREATE TABLE command
• TABLE is followed by the table name
• Follow this with the names and data types of the columns in the table
• Data types define type and size of data
• Table and column name restrictions
• Names cannot exceed 30 characters
• Must start with a letter
• Can contain letters, numbers, and underscores (_)
• Cannot contain spaces
