Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database Systems Assignment 1 for CSCI 585 - Fall 2009 - Prof. Dennis Mcleod, Assignments of Deductive Database Systems

University of Southern California (USC)Deductive Database Systems
Prof. Dennis Mcleod

The instructions and specifications for assignment 1 of the database systems course, csci 585, taught by professor dennis mcleod in the fall 2009 semester. The assignment includes designing a conceptual schema using ciom notation, comparing ciom and eer models, and solving short problems related to database design.

Typology: Assignments

Pre 2010

Uploaded on 11/08/2009

koofers-user-5dl
koofers-user-5dl 🇺🇸

9 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CSCI 585 – Database Systems – Fall 2009
Professor Dennis McLeod
Assignment 1
Due: 2 p.m., October 1, 2009 (before lecture)
(Hard copy submission only)
Submission Instructions:
The homework is due at the beginning of class on the due date shown. You should submit your
homework in hard copy (paper) format. No electronic submission is accepted for this homework. DEN
students should follow the DEN Homework Procedures to send their homework to the DEN Document
Support Center.
Late homework is strongly discouraged; if you submit late you will be assessed a major penalty. Please
remember you must do all three assignments and take both exams in order to pass the course.
Part 1: CIOM Design (46 points)
Design a CIOM conceptual schema that incorporates the specification described below. You should use
the notation given in the class. Your diagram should indicate all the classes, subclasses, set operator
classes, attributes, attribute value classes, inverse attributes, and cardinalities. In your design, you can
make and state reasonable assumptions if they are not provided in the specification. Your schema should
capture as much information about the application domain data semantics as possible (as stated in the
specification).
Weather Information
Weather information records for a city the temperature, humidity, wind, outlook, and date
(mm-dd-yyyy); there is one recording per day. There are three special kinds of weather information to
be captured, based on outlook – which can be “Rainy”, “Sunny”, or “Snowy”.
City Information
For cities, we record name, state, and geo-coordinates, and of course relate the city to its weather
information. The geo-coordinates are the longitude and latitude of the city center. A hot city is a city
pf3

Partial preview of the text

Download Database Systems Assignment 1 for CSCI 585 - Fall 2009 - Prof. Dennis Mcleod and more Assignments Deductive Database Systems in PDF only on Docsity!

CSCI 585 – Database Systems – Fall 2009

Professor Dennis McLeod

Assignment 1

Due: 2 p.m., October 1, 2009 (before lecture)

(Hard copy submission only)

Submission Instructions : The homework is due at the beginning of class on the due date shown. You should submit your homework in hard copy (paper) format. No electronic submission is accepted for this homework. DEN students should follow the DEN Homework Procedures to send their homework to the DEN Document Support Center.

Late homework is strongly discouraged; if you submit late you will be assessed a major penalty. Please remember you must do all three assignments and take both exams in order to pass the course.

Part 1: CIOM Design (46 points)

Design a CIOM conceptual schema that incorporates the specification described below. You should use the notation given in the class. Your diagram should indicate all the classes, subclasses, set operator classes, attributes, attribute value classes, inverse attributes, and cardinalities. In your design, you can make and state reasonable assumptions if they are not provided in the specification. Your schema should capture as much information about the application domain data semantics as possible (as stated in the specification).

Weather Information Weather information records for a city the temperature, humidity, wind, outlook, and date (mm-dd-yyyy); there is one recording per day. There are three special kinds of weather information to be captured, based on outlook – which can be “Rainy”, “Sunny”, or “Snowy”.

City Information For cities, we record name, state, and geo-coordinates, and of course relate the city to its weather information. The geo-coordinates are the longitude and latitude of the city center. A hot city is a city

where the temperature on 09-14-2009 is over 80 (F). A humid city is a city where humidity on 09-14-2009 is over 60 (%). A hot and humid city is both a hot city and humid city. For each hot and humid city, we record the employees (see below) who monitor the city (for possible problems). We also have special kinds of cities: attractive cities and unattractive cities. For attractive cities we have a text explanation of why it is considered attractive.

Person Information For each person, we record a unique SSN (Social Security Number), name, city (of residence), and (main) phone number. An employee is a special kind of person, for which we record a unique employee ID, starting Date, gender, and age. An employee has managers who are also employees. Engineers and Staff are special kinds of employees. For engineers, we record expert level. For staff, we record a section.

Part 2: Comparing CIOM and EER (30 points)

Compare and contrast “CIOM” with the “EER model” in 200 words or less.

Part 3: Short Problems (24 points)

  1. Given the many-to-many relationship shown below as an attribute/inverse pair in CIOM:

Suppose that the date a doctor diagnosed a patient is to be added to the conceptual schema. What changes would you make to the above to accommodate this additional information?

  1. Consider the following CIOM conceptual schema fragments. Based on the given information, state the attributes of the members of classes C5 and C6. Briefly explain your answer.