Problem 1 (total 24 points) Assume the following `real-world' environment concerning a
small supermarket, the Yappy Valley Culinary Boutique (YVCB). YVCB is organized into departments, each of which has some employees. Items are sold by departments, and a
Introduction To This Class
INFS 614 Professor Smith
M IT R E
Lets Go Over the Syllabus .
0 0 0
Welcome! Your experience with databases? About me: - database scientist at MITRE since 93 database - current interests: bioscientific databases, security/pr
INFS614, GMU, Lecture 2
Everyone have texts, Oracle accounts? Homework #1 is on the website. Lectures will follow text, but I may add some materials. Ill try to let you know when.
You are responsible for both on tests.
INFS614, GMU, L
Answer 2.3 The ER diagram is shown in Figure 2.1.
Exercise 2.4 A company database needs to store information about employees (identied by ssn, with salary and phone as attributes), departments (identied by dno, with dname and budget as attrib
INFS614 George Mason University An Example for ER Modeling Assume the university computing services (UCS) administers all campus computer networks. Each computer in a network is uniquely identifed by an inventory number, and also has a name (e.g., ise.gmu
HW 1a is due today we will go over a solution after the break which will help you with HW 1b HW 1b is due next week HW 2 will be assigned next week
For next week:
read sections 4.1 and 4.2 (relational algrebr
Relational Calculus (TRC) All and Only Queries
Example: Find sailors whove reserved all red boats (1)
S a ilo r s w h o h ave r eserved a ll r e d b o a ts T h e an sw er set S a ilo r s f o r w h ic h th e r e e x is ts a r e d b o a t th e y
Homework 1b due today
you will get 1a and 1b back together
work exercise 4.3 in text (relational algebra only), problems: 1, 3, 4, 7, 8, 10, and 11. due next week
TCP(transmission control protocol)
full dulplex two way communication
provides guanrantee of packets sent
ensures packets are properly routed and arrived intact
intercommunication between protocols using IP (internet protocol)
IP has 32 and 128 bit