G22.1170 Fundamental Algorithms, Spring 2015
Prof. Joel Spencer, ciww 829
The OLTP system data for the Fitchwood Insurance Company is in a series of flat files. What process do you
envision would be needed in order to extract the data and create the ERD shown in Figure 9-21? How often
should the extraction process be perf
Modify the Product_T table by adding an attribute QtyOnHand that can be used to track the finished goods
inventory. The field should be an integer field of five characters and should accept only positive numbers.
ALTER TABLE PRODUCT_T
Write an SQL command that will find any customers who have not placed orders.
SELECT * FROM CUSTOMER_T
WHERE CUSTOMERID NOT IN (SELECT CUSTOMERID FROM ORDER_T);
Write an SQL command to display the order number, customer nu
Examine the three tables with student data shown in Figure 9-1. Design a single-table format that will hold all of
the data (nonredundantly) that are contained in these three tables. Choose column names that you believe are
most appropriate for these
Session 1 Main Theme
Introduction to Database Systems
Dr. Jean-Claude Franchitti
New York University
Computer Science Department
Courant Institute of Mathematical Sciences
Presentation material partially based on textbook slides
Lecture 2 A
Oracle Data Modeler
Goal of normalization?
Minimize data redundancy.
Why minimize data redundancy?
Three Types of Data Anomalies
Advanced Relational Database
Carnegie Mellon University
Objectives of course
Web site - S
Index should be defined on these attributes:
Primary/unique key index on EmployeeID of EMPLOYEE table and secondary key index on
EmployeeID of PERFORMANCE table. These attributes should be indexed because they are the
primary key of each table