CIS336 Course Discussions Week 3

$9.00

CIS336 Course Discussions Week 3
What role do different constraints play in maintaining referential integrity and data integrity…

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

Description

CIS336 Course Discussions Week 3

CIS336 Course 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?

These constraints work to maintain referential integrity by ensuring that the tables are able to reference one another correctly, but they’re also used in order to keep the efficiency of data management low enough that the system is usable by more than one person. An incorrectly indexed database, an erroneous SELECT call, or other mistakes that involve these constraints can lead to the entire database locking up or working incorrectly…

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?

According to this week lesson, the SQL statement to create a table should start by using the CREATE statement, specifying a name for the table, and then defining within the create statement the parts of the table (columns, data types, constraints, etc.). The basic syntax to create a table is as follows. Keep in mind that it depends of what kind of value you will stored in that column you can use data type INT or DECIMAL or DOUBLE to any data value that is a number.
CREATE TABLE Devry(
Student_id CHAR(9),
Student_first_name VARCHAR(15),
Student_last_name VARCHAR(15),
Student_campus VARCHAR(25));