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 ).