Unit 3 Assignment 2_ Implementing the Physical Model Using SQL Data Definition Language (DDL)
docx
keyboard_arrow_up
School
Purdue Global University *
*We aren’t endorsed by this school
Course
234
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by Savannah_98
Unit 3 Assignment 2: Implementing the Physical Model Using SQL Data Definition
Language (DDL)
Outcomes addressed in this activity:
Unit Outcomes:
●
Describe the elements to be included in the physical data model.
●
Create the database using Designers in SQL Server Management Studio.
●
Associate column names, data type, and number of characters for each attribute.
●
Identify the primary keys for each of the tables.
●
Recognize any foreign keys required for each of the tables.
●
Identify the elements of the physical data model to create a database schema.
●
Use CREATE keyword to create databases, tables, columns, keys.
Course Outcome:
IT234-2: Explore Data Definition Language (DDL) statements to define the database
structure or schema.
Purpose
In Assignment 1 of Unit 3, you created a physical model for a database using SQL Server
Management Studio Designer tools. You can also create a database using SQL Data
Definition Language (DDL) statements. In this unit, you will create the same database using
the SQL CREATE statement to create the database and the tables. In business, you will
have choices of different methods for creating a database, so you want to be familiar with
the various options.
Assignment Instructions
You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server
Management Studio (SSMS) for this course. You can download the latest versions of these
free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Use the SQL Management Studio Query Window to implement a new version of the Movies
database. You will name this database Movies_2.
●
Create the database using the SQL CREATE statement.
●
Create the tables using the SQL CREATE statement.
●
Associate column names and datatype using the SQL create statement.
●
Establish the primary and foreign keys for each table.
●
Create a screenshot of your SQL Queries that you used to create the database and
tables.
You will need to use the established database design diagram and Movies Dataset you
used in Assignment 1 of this unit for the Movies 2 implementation. Download and use the
diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be
installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class,
and unit Assignment at the top of your paper. Embed the screenshots of your SQL
statements and confirmatory output (e.g., table structure definitions) into the Word
document.
Also review the university policy on plagiarism. If you have any questions, please contact
your professor.
The assignment is due by the final day of the Unit 3 week.
Directions for Submitting Your Assignment
Name your assignment document according to this convention:
IT234_<YourName>_Unit3_Assn2.docx. (replace <YourName> with your full name). Submit
your completed assignment to the Unit 3 Assignment 2 Dropbox by the final day of the Unit
3 week.
Review the Unit 3 Assignment 2 Rubric before beginning this activity.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help