CIS 336 Devry Course Tutorial (devrycart.com)
7 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by fadri
Scoop.it!

CIS 336 Week 5 Group Project Task 3

CIS 336 Week 5 Group Project Task 3 | CIS 336 Devry Course Tutorial (devrycart.com) | Scoop.it
Develop the SQL statements to insert records into the database
fadri's insight:

For more course tutorials visit

www.devrycart.com

 

 

Task 3 - Verification of Logical Model(45 points)

Develop the SQL statements to insert records into the database. You should ensure that the data  in the database is sufficient to allow for each of the reports requested by Ms. Smith to be tested.

You need to show a minimum of three insert queries for each database table that you have created.

Some tables will obviously require more to ensure that all of the required data is in the database (i.e., the packages table, program table, etc). To submit this task, add a comment heading called INSERT STATEMENTS to your corrected SQL script from Task 2. 

more...
No comment yet.
Scooped by fadri
Scoop.it!

CIS 336 Final Exam 1

CIS 336 Final Exam 1 | CIS 336 Devry Course Tutorial (devrycart.com) | Scoop.it

Most DBMS are referred to as _____________database management systems.

fadri's insight:

For more course tutorials visit

www.devrycart.com

 

 

1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4)

elemental
linked
hierarchical
relational

2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4)

information
processing
applications
programming

3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make

 use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)

referential
restrictive
secondary
redundant

4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table?
(Points : 4)

UNIQUE
PRIMARY KEY
FOREIGN KEY
NOT NULL

more...
No comment yet.
Scooped by fadri
Scoop.it!

CIS 336 Week 1 iLab 1 Devry University

CIS 336 Week 1 iLab 1 Devry University | CIS 336 Devry Course Tutorial (devrycart.com) | Scoop.it

L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data mode

fadri's insight:

For more course tutorials visit

www.devrycart.com

 

 

L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD).

In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, or unique identifier. Once you have decided the primary key of the relationship, you have identified the "one" side of the relationship. Note that for an RD, the foreign key "many" side of the relationship points to the primary key "one" side. The "one" side should have the arrowhead point of the connecting line. This is different than an entity/relationship diagram (ERD) that we will draw next week, where the "many" side has crow's feet.

more...
No comment yet.
Scooped by fadri
Scoop.it!

CIS 336 Entire Course

CIS 336 Entire Course | CIS 336 Devry Course Tutorial (devrycart.com) | Scoop.it
CIS 336 Entire Course: Devry University
fadri's insight:

For more course tutorials visit

www.devrycart.com

 

 

 

CIS 336 Entire Course: Devry University

 

more...
No comment yet.