CIS $3050$ Assignment #$1$ Introduction to SQL

Summer $2024$

Assignment Description

You are to practice Microsoft SQL by completing the two parts of this assignment in SSMS$.$

Part A

$$ Watch the two SQL Express$/$SSMS tutorial videos in the Canvas.

$$ Downloaded Microsoft SQL Server Management Studio $20\mathrm{.}1($SSMS$)$ with SQL Express $2019$

$$ Open this assignment description document $($Assignment #$1$ Introduction to SQL$.$pdf$).$

$$ Download and unzip Assignment #$1.$zip.

$$ Open Module $7-$ Introduction to SQL$.$pdf$.$

$$ In SSMS$,$ create two databases named CH$\_07\_$your first initial and LAST Name $($e$.$g$.,$ CH$\_07\_$dHWANG$)$ and

CH$07\_$SAMPLE$\_$your first initial and LAST Name $($e$.$g$.,$ CH$07\_$SAMPLE$\_$dHWANG$).$ This is important because

the naming will show that the work is your own.

$$ Following slide by slide, copy all SQL statements in the Module $7-$ Introduction to SQL$.$pdf$,$ paste them into

the query windows in SSMS$,$ and execute them to see the results.

$$ When you finish all the slides, take four screenshots that show $($image $1-4$ are for illustration purpose$)$:

$$ The components of the two databases: CH$\_07\_$your first initial and LAST Name. $($e$.$g$.,$ image $1)$ and

CH$07\_$SAMPLE$\_$S$22($e$.$g$.,$ image $2).$

$$ The structure of the two tables: dbo.CUSTOMER $($e$.$g$.,$ image $3)$ and dbo.EMPLOYEE $($e$.$g$.,$ image $4).$

$$ Paste the four images into a Word docoment named Assignment $2$ Part A $$ your first initial and LAST

Name.docx $($e$.$g$.,$ Assignemnt $1$ Part A $$ DHWANG.docx$).$

Image $1$ Image $2$

California State Polytechnic University, Pomona

Image $3$ Image $4$

Part B

$$ Open Assignment #$1$ Introduction to SQL$.$ppt and the following three SQL script files:

o Ch$07\_$SaleCo.sql

o Ch$07\_$ConstructCo.sql

o Ch$07\_$LargeCo.sql

$$ In SSMS$,$ run the three SQL script files to create the needed tables and data for this assignment.

$$ Fill in your answers in the blanks in Introduction to SQL$.$ppt$.$

California State Polytechnic University, Pomona

$$ Remove the round brackets in the SQL statements, copy and paste them into the query window in SSMS$,$

and execute them. If there is an error, fix your answers until it works.

$$ When you finish it$,$ save the Introduction to SQL$.$ppt to Introduction to SQL$.$pdf and name it as Assignment $1$

Part B $$ your first initial and LAST Name.pdf $($e$.$g$.,$ Assignemnt $1$ Part B $$ DHWANG.pdf$).$

Final Deliverables

$$ Email Assignment $1$ Part A $$ your first initial and LAST Name.docx and Assignment $1$ Part B $$ your first

initial and LAST Name.pdf to dhwang@cpp$.$edu using the subject: $$CIS $3050$ Assignment $1.$

$$ Due date: $11$:$59$ pm$,$ June $30,2024.$

Grading

$$ Part A: Completeness: $50\%(2$ points off for each element in Image $1,2,3,$ and $4.)$

$$ Part B: Completeness: $50\%(3$ points each blank; $104$ points total$)$