I have final tomorrow about sql. and this is what i suppose to bring but i can not create it because i do not get it and i do not have sql in my computer. annd i need it for tomorrow morning can someone please help me i need answer for the document i attached thank you.

CIT 140
Student must create a database for a store. The database must reflect the necessary tables and have
integrity. Here is a suggested database layout for an imaginary Gadgets store. Use this as a guide.
Do not copy the database, tables or fields.
Needed information:
● The store sells electronic gadgets: cell phones, players, radios, GPSs, etc.
● When describing the store, ignore employee salary information
● Provide a writeup that describes your reasoning and layout (10pts) GADGETS
Column
Name
GADGETID
GADGETNAME
GADGETDESC
GADGETPRICE Data
Type Lengt
h
— NULLs
Allowed
?
No DEFAUL
T
Value
— PRIMAR
Y
KEY?
Yes FOREIG
N
KEY?
No Refers
To
Table
— SMALLIN
T
VARCHAR
VARCHAR
DECIMAL 15
50
6 + 2 No
Yes
No —
—
0 No
No
No No
No
No —
—
— Data
Type Lengt
h SMALLIN
T
VARCHAR
VARCHAR
VARCHAR
VARCHAR — NULLs
Allowed
?
No DEFAUL
T
Value
— PRIMAR
Y
KEY?
Yes FOREIG
N
KEY?
No Refers
To
Table
— 10
10
15
15 No
No
No
No —
—
—
— No
No
No
No No
No
No
No —
—
—
— EMPS
Column
Name
EMPID
LOGIN
PASSS
FNAME
LNAME Page 2 CUSTOMERS
Column
Name
CUSTID
CUSTNAME Data
Type Lengt
h
— NULLs
Allowed
?
No DEFAUL
T
Value
— PRIMAR
Y
KEY?
Yes FOREIG
N
KEY?
No Refers
To
Table
— SMALLIN
T
CHAR 50 No — No No — SALES
Column
Name
SALEID
SALETS
GADGETID
EMPID
CUSTID Data
Type
SMALLIN
T
DATETIM
E
SMALLIN
T
SMALLIN
T
SMALLIN
T Length
— NULLs
Allowed?
No DEFAULT
Value
— PRIMARY
KEY?
Yes FOREIGN
KEY?
No Refers
To Table
— — No — No No — — No — No Yes GADGETS — No — No Yes EMPS — No — No Yes CUSTOMERS Example:
GADGETID SMALLint not null primary key….
GADGETID SMALLINT NOT NULL FOREIGN KEY REFERENCES GADGETS(GADGETID)
….
1. Create 4 tables similar to the sample above.
2. Add 10 rows in each table.
3. Use the snipping tool to submit your code that reflects the created tables, queries, and database
diagram. (above totaling in 90 points-- See Rubric on Schoology)
a.Write a query to show details for the entire items that have ‘r’ in the Gadget name.
b.Write a query to display the list of passwords for the entire employee whose login
contains ‘m’. (or a similar Query)
c.Write a query to find how many employees are there.
d.Using a join, write a query to find number of Gadgets bought by each customer.
e.Create a select statement to find out the last date gadgets were ordered.
4. Explain about your project in one page.(10 points)
At the completion of your work, submit all your code in one document. Create your Project
description in another document. Provide each query on schoology separately. Page 3

• 1493959319-final.docx

ComputerScienceExpert

(11)

Status NEW Posted 05 May 2017 04:05 AM My Price 9.00

-----------

Attachments

file 1493959324-Solutions file 2.docx preview (51 words )

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 -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer