(Solution) IDS 410 - Business Database Technology Spring 2016 Individual Assignment #3 (database Implementation) Database Implementation For A Simple Restaurant... | Snapessays.com


(Solution) IDS 410 - Business Database Technology Spring 2016 Individual Assignment #3 (database implementation) Database Implementation for a Simple Restaurant...


Attached are the instructions for this assignment and sample DDL given by teacher on how our script is supposed to look. Teacher wants it submitted as a "script file". I need this by Monday morning at 10:00.IDS 410 – Business Database Technology

 

Spring 2016

 

Individual Assignment #3 (database implementation)

 

Database Implementation for a Simple Restaurant System

 

Assigned Date: February 25, 2016.

 

Due Date: March 8, 2016

 

Problem Statement

 

For the third assignment, you will use the Data Definition Language (DDL) to create ten Microsoft Access

 

tables. Using Notepad, please create a script (text) file that contains CREATE TABLE definition for each of the

 

ten relations in the Simple Restaurant’s relational schema, which I have included on the last page. Please use

 

this relational schema as your reference to do the Create Table statements. Use the following format to name

 

your script file: yourNetidHwk3.txt. If your UIC email address is [email protected], your Netid would be abc and

 

therefore you should name your script file abcHwk3.txt.

 

To get started, I have included

 

sample

 

DDL statements (see below) to create four tables: Customer_t, Order_t,

 

Product_t, and OrderLine_t. You might want to test them by executing each of them in Microsoft Access.

 

Note

 

that you do not need to submit this four sample DDL statements.

 

Sample Data Definition Language Statements to create tables using Microsoft Access. Follow these steps:

 

1.

 

Launch Microsoft Access 2013 or Access 2010 and create a blank database. Name the database file as

 

follows: SampleDB

 

2.

 

Click the Create tab and select Query Design.

 

3.

 

Click the Close button on the Show Table window.

 

4.

 

Be sure the Design tab is selected. Select SQL View.

 

5.

 

Copy the Create Table Customer_t statement below and paste it on the Query1 window.

 

6.

 

Be sure the Design tab is selected. Click the Run button.

 

7.

 

At this point, the Customer_t should have been created.

 

8.

 

Repeat steps 5 and 6 above to create Order_t, Product_t, and OrderLine_t tables.

 

Create Table Customer_t

 

(

 

Id

 

AutoIncrement Not Null,

 

FirstName

 

Varchar(20) Not Null,

 

LastName

 

Varchar(20),

 

Primary Key(Id)

 

);

 

Create Table Order_t

 

(

 

Id

 

AutoIncrement Not Null,

 

OrderDate

 

DateTime Not Null,

 

CustId

 

Int Not Null,

 

Primary Key(Id),

 

Foreign Key(CustId) References Customer_t(Id)

 

);

 

Create Table Product_t

 

(

 

Id

 

Varchar(10) Not Null,

 

Name

 

Varchar(30) Not Null,

 

Description

 

Varchar(30),

 

Finish

 

Varchar(30),

 

UnitPrice

 

Currency Not Null,

 

Primary Key(Id)

 

);

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147718979.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote