CIS336 Discussions Week 3

$9.00

CIS336 Discussions Week 3
What is the importance of constraints in a physical model? What role do different constraints…

SKU: CIS336 Discussions Week 3 Category: Tags: , , ,

Description

CIS336 Discussions Week 3

CIS336 Discussions Week 3

All Students Posts 83 Pages 

Building the Physical Model – 40 Pages 

What is the importance of constraints in a physical model? What role do different constraints play in maintaining referential integrity and data integrity? It is possible for a table to be in BCNF but not in 3NF; do you concur? Why or why not?  Revisiting foreign keys, what would impact the ability to add or delete rows from a table or the ability to drop tables from a database schema?  What should be some of the considerations?….

Lab Forum – 43 Pages 

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. How about sharing with the class 2-3 SQL insert statements to populate the Student table? Do you have any tips on how to use Snipping Tool?  Are there are similar tools available that you want to share with the class?….