HomeWork1_Part1

HomeWork1_Part1 - CSCI 585 - Database Systems Fall 2010...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CSCI 585 - Database Systems Fall 2010 Homework Assignment 1: Part1 Due date: Friday 09/17/2010 Project Description The goal of this assignment is to Part 1: Design a conceptual schema using the (E) ER Data model Part 2: Incorporate this schema into an OR-DBMS, and Part 3: Run queries on this database. Part 1: Extended ER data model (50 points) Design a schema that incorporates the specification described below as efficiently as possible. You should submit a written diagram of your schema design using the notation given in the class. In this diagram, indicate all the classes, subclasses, relationships (weak & strong), relationship cardinalities and degrees, total participations, attributes, and primary keys. In addition, specify whether each attribute is single-valued or multi-valued, stored or derived, and atomic or composite. In your design, you can make and state reasonable assumptions if they are not specified in the specification. Design Specification
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/26/2010 for the course CSCI 585 taught by Professor Shamsian during the Fall '08 term at USC.

Page1 / 2

HomeWork1_Part1 - CSCI 585 - Database Systems Fall 2010...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online