Think about your lab project to answer the following questions.
1. What is your understanding of Entity Integrity Vs Referential Integrity. Illustrated with
simple examples for ease of understanding of the concepts.
Entity Integrity is the mechanism
You have been hired as a consultant by UMUC to help with their student information
system. I would like you to login to my.umuc.edu and choose one of the functionalities
(enrollment/registration, payment, etc.) of your choice, then write a simp
1. Refer to your project and explain different types of SQL (DDL, DML & DCL) with
suitable examples. Post your ERD for ease of understanding by fellow class-members.
DDL (Data Definition Language)
DDL statements are used to alter/modify a database or
1. Data Anomalies - Explain in your own words using tables from your lab project. Also
describe how such anomalies could be prevented.
Ans: Data anomalies are the problems or issues which can occur in un-normalized databases
which may be poorly organized.
Briefly explain the meaning of the ACID properties and some concurrency issues with
respect to your project.
ACID properties are an important concept for databases. The acronym stands for Atomicity,
Consistency, Isolation, and Durability.
The ACID propert
1. UMUC recruits both full time and part-time staff. How will you illustrate this scenario
using a specialization hierarchy (include some sample attributes).
Common attributes to both full time and part-time staff include: first name, last name,
Chapter 4 Problem 1 SELECT CustNo, CustFirstName, CustLastName, CustBal FROM Customer; Problem 2 SELECT CustNo, CustFirstName, CustLastName, CustBal FROM Customer WHERE CustState=CO; Problem 3 SELECT * FROM Product WHERE ProdPrice>50.00 ORDER BY ProdMfg,
Chapter 7 Problem 13 Insertion anomalies: - Inserting a new category number requires inserting an expense report number. - Inserting a new expense report number forces to insert a new category number. Update anomalies: - If I update the category name or l
Chapter 9 Review Sheet 1. Outer join generate a new table with the matching rows as well as non matching rows from other tables. Suppose that we have the following tables: Table1 Value A B C Table2 Value A B D
What would be the output of the INNER JOIN? W
13. There are many modification anomalies in the big expense report table. Insertion anomalies: Since ExpItemNo is the primary key, information about expense reports, expense categories, and users cannot be inserted unless there exists an expense item num
1. You will create a Statement of Work document this week for your project. Based upon
your understanding of this week's reading what are your thoughts on ERD and how
does this fit into your design process?
ERD shows the graphical representation of a
Using UMUC Library Resources, locate a good reference about SDLC methodologies and
discuss briefly how it can help database development.
We can use the waterfall process as a means of identifying the tasks that are required, together
with the input a
Pick one of the six general testing principles described in the textbook. In your own
words, briefly summarize it and explain why it is important. (Pick one not already
discussed by another student)
I would like to discuss here about the second general p
Dr. Igwe Spring 2015
Fill in the blank in Questions 1-10
Exists when it is possible to make changes in the data storage characteristics without affecting an application programs ability to access data.
What was the performance of different sales promotions?
Select LAB_PROMOTIONS_DIM.PROMO_SUBCATEGORY, LAB_PRODUCTS_DIM.PROD_NAME,
to_char (sum (AMOUNT_SOLD),'9,999,999,999') sales$
From LAB_PROMOTIONS_DIM, LAB_PRODUCTS_DIM, LAB_SALES_FACT
efore delving into the specics of data warehouse/business intelligence
(DW/BI) design, development, and deployment, we want to rst introduce
the Kimball Lifecycle methodology. The Kimball Lifecycle provides th
Increasing Database Performance Using Index
Database performance is a bottleneck issue that need to be address adequately.
Performance methodology starts by investigating waits at the instance level and follows a series
of steps till the proc
According to Inmon, a data warehouse is a subject-oriented, integrated, nonvolatile, time variant
collection of data in support of managements decisions.
Subject-Oriented: A data warehouse can be used to analyze a particular subject area such as "Finance"
Types of changes to SQL queries-1
1. In some situations involving the use of correlated queries, temporaries are useful.
Consider the following query, which retrieves the highest paid employee in each
FROM EMPLOYEE E
WHERE Salary =
MongoDB is a NoSQL document database that provides high performance, high
availability, and easy scalability.
Main Features of Mongo database
1. Document Database
Documents (objects) map nicely to programming language data types.
http:/www.uninova.pt/~cam/is/ddb.doc Luis M. Camarinha-Matos
Distributed database overview
A distributed database can be defined as consisting of a collection of data with different parts under the control of separate DBMSs running on independent computer
Solutions for the class exercises Solutions for conversion problem 1 on pg 210 1. The conversion rules used for this problem Entity Type Rule: generate home, owner, agent, and office tables 1-M Relationship Rule: foreign keys in home (agentid and ssn) and