SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 3 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Jan 2018 My Price 7.00

School of Engineering Technology Applied Database 1

Need help with writing code for database?

School of Engineering Technology

Applied Database 1

COP4708

Assignment 4

Objective:

The purpose of this assignment is to demonstrate the proper writing for SQL code, there is NO NEED TO USE ORACLE, ACCESS, OR ANY DBMS (JUST A CODE IN MS WORD)

Assignment Deliverables:

Write SQL code to create a STUDENT table that includes the following attributes:

Student ID

First Name

Last Name

Street Address

City

State

Zip Code

Phone

Email

In the code remember to include data type, data size, and if that field is required or not. The selected data types and data size should be logical. For example you cannot use Char (10) for street address; size 10 is very small compared to many long street addresses that we deal with every day. Having a short size data will create error messages.

Write SQL statement to :

Insert at least three rows of fake data (any names, any addresses,…) into the table above.

Add a column called StudentStatus to the table above.

Add a new constraint to limit the student zip code to be within the following group (32117, 32116, 32115, 32114)

Count the number of rows in the table

Show the first 3 records of data.

Delete the column StudentStatus.

Create a view that shows only First Name, Last Name, and Email

View records of students living in area code 32116.

Delete the table student

Note: Just write the code in a word document and there is no need for implementation in any DBMS at this point.

 

Answers

SophiaPretty
(5)
Status NEW Posted 12 Jan 2018 01:01 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)