cs585_20103_assignment-1 - CSCI 585 — Database Systems...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CSCI 585 — Database Systems — Fall 2010 Professor Dennis McLeod Assignment 1 Due: September 23, 2010 @ 02:00 PM PDT [Hard copy submission] In this assignment you will explore database design using CIOM and EER to achieve a better understanding of conceptual schema design, as well as address some key issues in conceptual modeling. Consider the following application environment for a cell phone tracking system: (for problems 1 and 2 below): For each phone we keep track of its make (manufacturer), model name and its operating system. The operating system has a name and version number (6. g. Symbian, Android 2.2, iOS 4). A cell phone’s radio type (GSM or CDMA) will determine its compatibility with a specific carrier. We call Android- based and iOS-based phones “smart-phones”. “Feature-phones” use other operating systems. For simplicity we assume a phone can have only one operating system. A cell phone carrier is the company providing you with the cell phone service. Each carrier has a name, website and supports only one network namely, GSM or CDMA. The carrier sells any phone that supports their network. For marketing reasons, the carrier maintains a list of cities that they provide services for. Each city has a name, state, coordinates (i.e. latitude and longitude) and the number of cell phone providers in that city regardless of their network. A “hot” city is a city in which three or more carriers operate. Otherwise a city is considered “cold” in terms of marketing. The end users of the service are called customers. Each customer has a name, a unique Social Security Number, date of birth and contact information. A customer's contact information includes their billing address, city of residence and a home phone number. A customer can only use a carrier who is available in their city of residence. A customer could have more than one phone with the same carrier and could contract with any carrier in his/her city. You may assume that a customer's cell phone number is tied to one phone which has a globally-unique IMEI identifier. Customers who are younger than 18 are called “youth” customers and we need to have their parents’ information (assume their parents are customers too). “Senior” customers who are older than 55 need an emergency contact. Problem 1 (35 points) Design a CIOM conceptual schema based on the above specification, which captures as much of the semantics of the application as possible. You should use the notation given in lectures. Your diagram should indicate all the classes, subclasses, set operator classes, attributes, attribute value classes, inverse attributes, and cardinalities. You may make and state in writing reasonable assumptions if they are not provided in the specification. Problem 2 (35 points) Design an EER conceptual schema based on the above specification, which captures as much of the semantics of the application as possible. You should use the standard notation shown in the course textbook. Your EER diagram should include all entities, attributes, relationships, cardinalities and both specialization and generalization hierarchies. You may make and state in writing reasonable assumptions if they are not provided in the specification. Problem 3 (30 points) This question is based upon the description on ontologies presented in selected reading 5 [SR5] : Identify the key similarities and differences between the view of ontologies in that paper and the view of database conceptual modeling as embodied in CIOM. Your answer must be less than two pages. [SR 5] Noy, N., and McGuinness, D. "Ontology Development 101: A Guide to Creating Your First Ontology". Stanford Knowledge Systems Laboratory Technical Report KSL-01-05 and Stanford Medical Informatics Technical Report SM—2001-0880, March 2001. Submission Instructions: Your submission must be prepared electronically. This means that all answers are to be typed, and all diagrams generated using programs such as Adobe Illustrator, Microsoft PowerPoint, Microsoft Visio or Google Drawing. For the written portion of this assignment use single line spacing and font size 12. Only hard-copy submissions are accepted for this assignment. DEN students should follow the DEN Homework and Grading Procedures for submitting their homework. This assignment is due before the class on the due date shown above. There is a 20% deduction per day for late submissions. Assignments more than 5 days late will not be accepted. Note that you must do all the assignments and take both exams in order to pass the course. Discussion Board and Student Collaboration Policy You should work on this assignment individually and within the realm of the USC Academic Integrity Guidelines. A discussion board for this assignment is available on DEN's Blackboard system. Use the discussion board as your main resource to post questions related to the assignment. We encourage you to discuss issues related to this assignment with other students without revealing and/or hinting at any answers. The TAs will participate in the discussions and answer questions on the board. ...
View Full Document

Ask a homework question - tutors are online