Unit 3 Assignment 1_ Implementing the Physical Model Using the Microsoft SQL Server Management Studi
.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 1: Implementing the Physical Model Using the Microsoft SQL Server
Management Studio Designer Tools
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.
Course Outcome:
IT234-2: Explore Data Definition Language (DDL) statements to define the database structure or
schema.
Purpose
When designing databases, you create three models: conceptual, logical, and physical. The Unit
3 assignment asks you to create a physical data model based on the Movies Dataset and the
established database design diagram. You will use the Microsoft SQL Server Management
Studio (SSMS) Designer tools to create the physical data model. Microsoft SQL Server and data
models are used in a variety of business scenarios to describe organizational data.
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
Before completing the Assignment, please watch the Unit 3 videos covering facets associated
with physical database modeling. Navigate to the Academic Tools area of this course and select
Library then Required Readings to access your texts and videos.
Based on the established
database design diagram
and the data contained in the
Movies
Dataset:
●
Identify the elements to be included in the physical data model.
●
Using SQL Server Management Studio Designer tools, create the database.
●
Using SQL Server Management Studio Designer tools, create the tables (convert entity
names to table names).
●
Using SQL Server Management Studio Designer tools, associate column names (convert
attribute names to column or field names), datatype, and number of characters for each
attribute (field).
●
Using SQL Server Management Studio Designer tools, establish the primary keys for
each of the tables.
●
Using SQL Server Management Studio Designer tools, establish any foreign keys for
each of the tables (here you are converting your relationships to foreign keys).
●
Create a screenshot of your SQL Management Studio showing the database and tables
you have created; embed this screenshot into your Word document.
Please use the following guidance document to help you complete this assignment
:
Instructions
for Using the Microsoft SSMS Designer Tools to Generate the Movies Database
You will need to use the established
database design diagram
and
Movies Dataset
for this
assignment. 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 from SQL Server Management
Studio showing the work performed for the creation of the database and tables.
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_Assn1.docx. (replace <YourName> with your full name). Submit
your completed assignment to the Unit 3 Assignment 1 Dropbox by the final day of the Unit 3
week.
Review the Unit 3 Assignment 1 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