Score for this quiz: 24 out of 30
Submitted Jul 20 at 8:34pm
This attempt took 50 minutes.
3 / 3 pts
(TCO 3) The _ column attribute will provide a value for a field if none is specified.
See the We
CIS336 Week 2 Quiz
3 / 3 pts
(TCO 2) Which statement is FALSE regarding a primary key?
Only parent tables must have a primary key.
The values must be unique.
It can be made up of multiple attributes.
The value cannot be NULL.
See the W
Devry Bis245 Week 1 Discussion 1 Latest 2015 October
Databases and Gathering Requirements (graded)
Why are databases important to business? How do databases generate sales and-or profits? What
databases do you interact with, and how do they benefit you?
Devry BIS245 Week 2 Discussion 1 Latest 2015 October
Entity Relationship (ER) Modeling (graded)
What role does the entity-relationship (ER) diagram play in the design process? Discuss the different
types of information represented in the ER diagram and th
Devry BIS245 Week 3 Discussion 1 Latest 2015 October
Conceptual Database Design (graded)
Why do you think organizing data into tables and relationships is a good way to design a database? How
do related tables improve the accuracy of data in a database?
Move a field by selecting it (and its label, if present), and then dragging it to the new location.
Right-click a field and use the commands on the shortcut menu to merge or split cells, delete or select
fields, and perform other formatting tasks." (Micro
Devry BIS245 Week 7 Discussion 1 Latest 2015 October
Database Navigation (graded)
Finding information in a database can be difficult unless you know what information you need and how
to look for it. Creating a navigation system or menu allows Access to ac
Devry BIS245 Week 1Quiz Latest 2015 October
(TCO 1) A database that organizes data in a set of overlapping tables is
which of the following?
Question 6 Question :
Student Lab Activity
BIS245 Database Essentials for Business with Lab
A. Student Name:
B. Lab 1 Part C Questions:
1. Entities in the conceptual model eventually are converted to tables in the database,
and the attributes conv
DROP TABLE IF EXISTS INVENTORY CASCADE;
DROP TABLE IF EXISTS LINE_ITEM CASCADE ;
DROP TABLE IF EXISTS PRODUCT CASCADE;
DROP TABLE IF EXISTS ORDER CASCADE;
DROP TABLE IF EXISTS STORE CASCADE;
DROP TABLE IF EXISTS EMPLOYEE CASCAD
CIS336 Week 6 Live Lecture Prof. Price
The session will begin at 7:00 PM CT
Week 6 TCOs
TCO6: Given an existing relational database and
requirements for changes in the database structure
you thrrough how to
t find, log iinto, and utilize the bas
sic features of
This document will step
Plus editor in
n Oracle. Th
his editor w ill be your m
main iLab to
ool for most of
the labs within the
Week 1 Ilab
2 .From examination of the sample data and your current understanding of businesses in which
orders could be placed either in person, over the phone, or over the Internet, determine if it
would be permissible for null values to be allowed fo
(TCO 3) The term first normal form (1NF) describes the tabular
format in which all of the following are true except
all the key attributes are defined.
there are no repeating groups in the table.
all attributes are dependen
(TCO 2) Explain what physical independence means.
Physical independence is a condition that exists when the physical model can be
changed without affecting the internal model. The phys
(TCO 7) To indicate which database table contains the data to
be selected by a query, the table name should be listed in the
Chapter 7, page 237 and
(TCO 8) If a Cartesian join is used to link table A which
contains five rows to table B which contains eight rows, there
will be _ rows in the results.
Chapter 8, page 294
CIS336: Lab 4 Answer Sheet
Your name _Jennifer Tabor_
from customers order by 1;
- Jennifer Tabor
- CIS 336 Course Project
- Week 5
SET SESSION storage_engine=InnoDB;
DROP TABLE IF EXISTS sale_details;
DROP TABLE IF EXISTS sales;
DROP TABLE IF EXISTS online_customer;
DROP TABLE IF EXISTS retail_customer;
DROP TABLE IF EXISTS purchase_
CIS336: Lab 5 Answer Sheet
Your name _Jennifer Tabor_
SELECT CONCAT(customer_first_name,' ',customer_last_name) AS
'Customer',customer_city, order_id, date_format(order_date, '%m/0/
%y') AS "Date"
FROM customers JOIN orders