Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sprint 36% 9:25 PM reggienet.illinoisstate.edu The following are the tasks that you need to complete for the seconed phase of the group project. Some Ace

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Sprint 36% 9:25 PM reggienet.illinoisstate.edu The following are the tasks that you need to complete for the seconed phase of the group project. Some Ace Auto Repair table names may conflict with those fronm the JLDB database from the chapters. You can use the team Oracle account to avoid this issue, or use table names lik ORDERI and CUST-x. 1. Create the relational schema for the Ace Auto Repair database using the entity and attribute names in Phase 1 solution posted on ReggieNet. referentialLintegrity arrows Remember, this is the table schema that looks like this: CUSTOMER 2. Write SQL codes in Notepad++to create your tables. While creating your tables, please include the necessary constraints (e.g, PK, FK, NOT NULL), declare default values as necessary and select the data types appropriate for the data on pages 2-5. Whenever possible, your constraints should be created at the table level. Document your design in a data dictionary (see Module2 slide #28 as an example). 3. Run the SQL commands in Oracle to build the tables. After your 4. Use the INSERT command to populate your tables with the required data (see pp. 2-5). After your commands have executed, run the SELECT FROM tablename; command once for each table, take screenshots of the results, and paste the images into the same Word file. Multiple screenshots may be Note: The dates in the RepairOrder table are not p Oracle's default format (DD-MMM-YY). One option is to reformat them into the default format Submit the following three (3) files via ReggieNet. Please DO NOT create a zip file: 1. A Word file containing: a the relational schema b the data dictionary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Management Databases And Organizations

Authors: Watson Watson

5th Edition

0471715360, 978-0471715368

More Books

Students also viewed these Databases questions

Question

What attracts you about this role?

Answered: 1 week ago

Question

How many states in India?

Answered: 1 week ago

Question

HOW IS MARKETING CHANGING WITH ARTIFITIAL INTELIGENCE

Answered: 1 week ago

Question

Different types of Grading?

Answered: 1 week ago

Question

What is DDL?

Answered: 1 week ago