The Relational Model 7:28 PM (CT)
Review the following LinkedIn Learning videos to help you with your assignments in this Unit.
Create a 5page MS Word document following APA guidelines (first person should not be used). Write this document for a technical audience.
Research and answer the following components:
1. Integrity Constraints
. Explain each of the following and provide examples:
2. SQL. Design a basic database with at least two tables (e.g., Pet Grooming Customer Database). For your specific database:
Briefly explain the purpose of the database. Provide a visual representation of your database’s tables.
Write an SQL statement to create a table.
Write an SQL statement to add a record.
Write an SQL statement to edit a record.
Write an SQL statement to delete a record.
Note: the title and reference pages do not count toward the page length requirement.
Save your document with the course, assignment, and your name (e.g., ITCO630_Unit2_IP_Neo_Anderson.docx). Submit your document for grading.
Refer to the Grading Rubric for this assignment.
This assignment will also be assessed using additional criteria provided here.
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.
Starks: Ch. 24, Appendix B & D
Read the following from the AIU Library:
Database Systems: A Pragmatic Approach
Evaluate the purpose, capabilities, and limitations of SQL.
Evaluate the relational database model.
There is no additional information to display at this time.
Extra Credit View Assignment Rubric
Unit 2 Individual Project
Unit: The Relational Model
Due Date: Tue,12/7/21
Grading Type: Numeric
Points Possible: 140
Deliverable Length: 5Page MS Word Document
Type: Individual Project
This assignment is the Common Assignment
Looking for tutoring? Go to Smarthinking
Online Deliverables: Submissions