Why do the sizes of the caches have to be different? why is L1 smaller than L2 at the same time L2 is
smaller than L3 (trying to minimize the "bottle neck"
1) Want a Faster Computer you'll need:
a) clock speed
b) more cores
Interrupt handlers e
History of the PC:
1642: Blaise Pascal invents a calculating machine 1801: Joseph Marie Jacquard invents a loom that uses punch cards 1800s: Charles Babbage attempts to build an
analytical engine (mechanical computer) Augusta Ada Byron develo
Functional models: describe business processes and the interaction of an info system with its
environment. 2 types:
1. use cases:
- describe basic functions: represent the way a business system interacts with its environment
- external or functional view
1. According to this article, the Waterfall process was responsible for the delay problems at
Microsoft. The reason is that Waterfall focuses too much on phases, which is not suitable for
software development. Take Visual Studio as a
Database #1 - Olympics
Country: [NAME, anthem, continent, population, contact person, # of participants]
Relationships with delegate, athlete, and referee (C_NAME in each of those as a foreign
Primary key = NAME
Delegate: [PASSPORT#, name, birthday
Database Design HW #5
1. Consider a relation R [V, W, X, Y, Z] with the following functional dependencies:
Fd1: (V, W) -> X
Fd2: (X, Y) -> Z
Fd3: (Y, Z) -> W
Is (X,Y) a candidate key of this relation? If not, what is the candidate key? Explain
Something a database or program must do to fulfill its function.
Following and observing a person as they go through their work routine.
This is the focus of a database. If the database is about the
LAB SESSION 7 & 8
ORACLE AND DDL
University of Cincinnati: OBAIS Department
IS3030 Spring 2017
Lab Instructors: Noha El-Saleh (002)
Morgan Eberle (003)
Use Oracle to create databases
How to view tables in Oracle
Data Definition Language (DDL) of Or
Lab Assignment 4 25 points
(Due at 8am on 3/10/17)
Implement the logical design of the Eauction database system described in this document
(creating a relational database) on the ORACLE platform using SQL DDL Stateme
Relationship types can have their own attributes.
In the logical design of relational database, we can create a new relation to represent a one-tomany binary relationship type.
A weak entity type can be the owner entity of another weak entity
Microsoft excel is a good data mgmt. tool because it organizes data as logical tables. FALSE.
R1: CONFERENCE (CONFERENCE_ID)
The primary key is CONFERENCE_ID.
R2: TEAM (UNIVERSITY_NAME, TEAM_ID, Division)
The primary key is (UNIVERSITY_NAME, TEAM_ID).
R3: GAME (TEAM_ID, GAME_ID, #of attendance, dat
Data Items: description of things, events, activities, & transactions recorded, classified, &stored, not organized w/ meaning. (3.16) 4 things to do with data: create,
disseminate, manipulate, & manage Information: refers to data that have been organized