CIS 111 Week 7 Lab 4 Structured Query Language( SQL)( 2 Papers)
FOR MORE CLASSES VISIT www. cis111study. com
Recognize the purpose and principles of normalizing a relational database structure.
Design a relational database so that it is at least in 3NF.
Use technology and information resources to research issues in database systems.
Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.
===================================================
CIS 111 Week 7 Lab 4 Structured Query Language( SQL)( 2 Papers)
FOR MORE CLASSES VISIT www. cis111study. com
This Tutorial contains 2 Papers Lab 4: Structured Query Language( SQL)
Refer to the database design crested in Lab 2: Modifying a Database Design in Visio to complete this Lab.
Perform the following steps in MySQL:
Create the tables and relationships from the database design discussed in Lab 2.
Add at least five( 5) records into each table( Note: You must determine the field values).