5, Analysis and Design (20 points)The WSP is a collection of overlapping applications for warehouse management, itsEntity/Relationship diagram representing the entities involved in is shown in the figure 2.1CUSTOMER1stored atnnownsITEMPLACEFigure 2All the functions (element processes) of the WSP system are listed in figure 3.- Add customerChange customer dataDelete customer- Delete place- Print customer item list- Print bill- Print stored items list- Query customersQuery customer's items- Query placesQuery stored itemsReceive paymentDeposit itemRetrieve itemAdd placeChange place dataFigure 3(1), please draw the domain class diagram and(2), please draw the use case diagram for the system.The domain class diagram and Use case diagrams can be drawn with modeling tools, orthey can be drawn by hand, photographed, and inserted here. (for each diagram, 5 pointsfor the correct format, 5 points for correct content)Answer question 5 here

Answered: (1), please draw the domain class…

Engineering

Computer Science

(1), please draw the domain class diagram and (2), please draw the use case diagram for the system.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

Identify all important concepts represented in the library database. Also, identify the abstractions of classification (entity types and relationship types), aggregation, indentification, and specialization/generalization. Specify (min, max) cardinality constraints. List details that will affect the eventual design but that have no bearing on the conceptual design. List the semantic constraints separately.
4.2 Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Legal system – business rules:• In the legal system, a judge hears many cases throughout their career.• Each case can be heard by multiple judges in some circumstances.• A case has a date and title that needs to be recorded in the database.• The name and surname of each judge needs to be stored.• A judge can have multiple qualifications (with minimum of one), and each qualification is related to only one specific judge.• For a qualification, the institution, description and year completed should be recorded. • A case is defended by a single lawyer, but a lawyer can defend many cases in their career.• The name and surname for each lawyer needs to be stored in the database
Identify all the important concepts represented in the library database case study described below. In particular, identify the abstractions of classification (entity types and relationship types), aggregation, identification, andspecialization/generalization. Specify (min, max) cardinality constraints whenever possible. List details that will affect the eventual design but that have no bearing on the conceptual design. List the semantic constraints separately. Draw an EER diagram of the library database.
A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spreadsheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
Data modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagram
A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
What kinds of data would you store in an entity subtype?
The crow's foot in a diagram a.) is only used to show N:M relationships. b.) shows the relationship between three entities. c.) indicates that more than one of that entity type can be involved in that relationship. d.) shows the minimum number of entities that can be involved in a relationship. When translating an ER model into database tables a.) each relationship is defined by a normal form. b.) each entity is represented with a table. D.) each relationship is represented with a table.
Please give a step-by-step answer. The ER Diagram must contain the ER-Diagram Symbols. Design an EER diagram for an Hotel Management System. The hotel wants to keep track of all their employees, customers, bookings, rooms and services. They have hired you to help them design the database for that purpose. You can design your EER as you wish, but it must satisfy the following constraints: a. there should be at least one overlapping-partial specialization/generalization. b. There should be at least five regular/strong entities [excluding subclasses] c. There must be a recursive relationship. d. There must be at least one 1:1 relationship. e. There must be at least one multivalued-composite attribute. Show all important attributes, entities and relationships in order to represent a clear and complete scenario. The EER diagram should be logically accurate and realistic, representing the database of the given scenario.
Data access, business logic, data presentation, and user interaction are all kept distinct using the Model-View-Controller design pattern. Additionally, it distinguishes data presentation from user interaction. Discuss or provide your thoughts on this explanation.
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the following business rule for a hotel group: a. Each hotel is located in a city. Some cities may have more than one hotel, but a specific hotel can only be located in one city. The name of the hotel and the name of the city must be stored in the database
Design ER diagram to model the online bookstore’s database, in which there are four entities, namely books, authors, publishers, and customers entities. Every book has an author and a publisher. Customers can order books. Information about payment, shipping, and stock of goods does not need to be included in the model.

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS