Database Project 2

Overview Create need database objects to handle the dietary application Objectives • Create a database • Create a tablespace • Create an oracle user for the new tablespace • Create tables and other needed objects • Import sample data into tables • Write scripts to verify test data in tables Data Layout Example Client Name Day of Week Food Quantity Calories Fat Carb Protein Fiber Weight John Monday Apple 1 90 0 90 0 0 90 Jan Monday Banana 1 100 0 9 8 0 40 Mike Mary Deliverables • Database Location of database files / control files / redo logs • Database Objects Describe tables Scripts for creating tables / indexes / constraints • Scripts for importing the data • Scripts for verify data importing • Startup / shutdown instructions • Instructions on rebuilding the application.