b. Create an UML class diagram that models the data relationships described in the following paragraph. • To be a collector you have to have one or more collections. • Each collection must have 2 or more items. • Each collection belongs to one collector. • A collection is made up of items owned. • A particular item may be in more than one collection (i.e. an old Coke sign may be in both a Coke memorabilia collection and a sign collection.)

b. Create an UML class diagram that models the data relationships described in the following paragraph. • To be a collector you have to have one or more collections. • Each collection must have 2 or more items. • Each collection belongs to one collector. • A collection is made up of items owned. • A particular item may be in more than one collection (i.e. an old Coke sign may be in both a Coke memorabilia collection and a sign collection.)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please help me with this question ERD diagram.
In The Given Sequence Diagram, In Which Class Should The MakePayment() Operation Be Defined?
Sub Class and Super Class belongs to model. a. ER b. Dimensional C. EER d. Relational Which of the following is true about Information? a. It is always useful without processing b. It is generally collection of unorganised facts c. It needs to be processed to provide answer to user queries d. It is raw Which of the following statements is true about the Composite Primary key? O a. It is composed of two or more attributes, but it must be minimal. b. It is composed of two or more relations, but it must be minimal. O c. It is composed of two or more attributes, but it must be maximal. d. It is composed of two or more entities, but it must be minimal. contains only columns that are non-transitively dependent on the primary key. a. INF b. 2NF c. 3NF d. UNF
Consider the following class diagram that models a company activities. A company is composed of many branches and each branch is located in a different city. Company's customers are subdivided into two categories: Regular and Privileged. Privileged customers are those that made at least 10 orders to the company. A customer can order items to the branch in his city, if any. The order will than be recorded by this branch. An order consists of a list of items. A discount of 5% will be applied for privileged customers. A discount of 10% will be applied if the order contains more than 8 items or if the total price of the order exceeds 100. Customer Order Item name: String name: String 0. date:Date /discount int name: String priceint 0. 0. canMakeOrder():Boolean isPrivileged() Boolean 0. 0. City Branch 0..1 name: String naner String Express the following constraints in OCL. 1. The number of items in an order does not exceed 15. 2. The number of items in an order does not exceed 10 for…
I. The fields in a class diagram written at the middle of a class diagram II. The fields in a class diagram should be written with the name of the access modifier I. The fields in the class diagram are used to represent the behavior of the object. Which statement is correct about fields in a class diagram O lonly O land Il only O , I, and III O l and IlII only
Question : Draw a sequence diagram to represent the scenario of "using vending machine purchase drinks". Four objects have been defined as follows. Add the following functions: (1) change when the customer pays more than the price of the purchased beverage; (2) return the customer's payment if the purchased beverage has been sold out, otherwise, it will be sold normally. Draw a complete sequence diagram showing the above functions. Customer Front Register Dispenser
Create a UML Class Model based on the requirements . Your Class Model is to include: All classes Attributes and Attribute Types Associations Multiplicity Primary and Foreign keys Any Inheritance, Composition or Aggregation. Building Maintenance system. A rental property management company wants to develop a ‘Building Maintenance System.’ This system will be used by the company to manage maintenance requests from tenants in the several rental buildings that it manages in the city. Each building has a maintenance manager. The maintenance manager is responsible for creating accounts in the system for each tenant in their building. A tenant can rent multiple apartments within the same building. Tenants can submit maintenance requests using this system. Each maintenance request will have a request ID, category, and description. The maintenance manager manages a maintenance crew in their building. Maintenance crew members can be members of more than one maintenance team. Maintenance crew…
Draw a UML class diagram for "clothing and other item donations" people can list the items available to donate. And people in need can request what items they need. please help, thank you.
Let's assume that you have been employed by a University to design Library Management System for the University. The following classes have been given to you to assist you create the class diagram. User Class – It manages all operations of user. Librarian Class – It manages all operations of Librarian. Book Class – It manages all operations of books. It is basic building block of system. Account Class – It manages all operations of account. Library database Class – It manages all operations of library database. Staff Class - It manages all operations of staff. Student Class - It manages all operations of student. Required You are required to create a complete class diagram.
3.1 Explain the difference between a link and an association? 3.2 Describe the following class stereotypes, and explain why it is necessary to distinguish among them. Boundary classes, control classes and entity classes? 3.3 Explain the nature and importance of encapsulation in object oriented programming? 3.4 What are the benefits of keeping all classes reasonably small and self-contained?
The requirements below partially describe a game management system (such as Steam) that is used for managing game installations of a player. Draw a UML class diagram describing an object-oriented system using the list of requirements below. Each user can own many games. Games have many copies in the system. Games have many achievements and collectibles. Each achievement can be accomplished by many players. There are two types of items in the system: seasonal item and collectible item. Users can obtain many items. There are three types of user interactions: post, reply and (game) review. Users can create many posts. Users can reply to a post. Posts can receive many replies. Reviews are written by users for a game. A user can write many reviews. A game can have many reviews. RQ1: Users own game copies not the actual games. RQ1: All user objects are managed by a user manager object in the system (design decision). RQ5&RQ6: Users own collectible items not actual collectibles. Each…
Question 2: Class diagram with multiplicities, attributes and subclasses (generalization) (3%). Draw a class diagram with multiplicities for the following College Library case: The system stores information about two main things: books and borrowers. A book has attributes for title, author, ISBN, year, and category. The borrower has attributes for first name, last name, phone number and address. Assume that a book must be borrowed by one borrower and a borrower can borrow many books. In addition, also include subclasses for the types of borrowers: student and faculty. Add appropriate attributes for each type.