The following is a system requirement for an inventory subsystem. The warehouse staff receives the products delivered by its supplier. The supplier submits the company with an invoice after its delivery. Interpret the above requirement statements by identifying at least FOUR (4) objects. Sketch these objects with at least 3 attributes and 1 method

The following is a system requirement for an inventory subsystem. The warehouse staff receives the products delivered by its supplier. The supplier submits the company with an invoice after its delivery. Interpret the above requirement statements by identifying at least FOUR (4) objects. Sketch these objects with at least 3 attributes and 1 method

Database Systems: Design, Implementation, & Management

11th Edition

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:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter2: Data Models

Section: Chapter Questions

Problem 3P

See similar textbooks

Similar questions

Entity-Relationship Diagram (ERD) is one of the data modeling tools that provides a software engineer with the ability to represent data objects, their characteristics, and their relationships. Use an ERD to describe the following scenario. A teacher is identified by an ID number (TID), last name (LName), and first name (FName). A project is identified by a project ID (PID) and title (T). A student is identified by an ID number (SID), last name (LName), and first name (FName). A teacher can supervise zero, one, or many students and a student is supervised by one teacher. A teacher must propose one or many projects and every project is proposed by one teacher. A student must work on one project and every project is worked by only one student.
Create an Entity-Relationship model for the following descriptions: Doctors, nurses, and patients have the following unique numbers respectively: doctorNo, nurseNo, and patientNo.
Create an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A…
Modify the following system sequence diagram to reflect the following: 1)The sales clerk can add more than one item to the ticket, every time they add an item, the system returns the price and description. 2) After displaying the total, only if the receipt was requested, the system returns the receipt. Sales Clerk validate Contractor (name or ID) contractor information create Ticket () additemto Ticker (item ID, quantity) price, description total := endSale () printReceipt() receipt System
Create a class diagram for the following requirements
Study the following. A customer can place one or more orders, but an order belongs to only one customer. A customer is described by its name, delivery address, and contact number. While an order is described by order number, order status, and order date. Only one payment is made for an order. An order can be paid for through one of two options. A payment is either cash or debit. A payment has an amount attribute. Cash payment is described by cash tendered, while debit payment is described by number, type, and expiry date 6.1 Use the scenario to draw a UML class diagram.
An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system. Consider the following description of a system: A university registrar’s office maintains data about following entities: Courses, including number, title, credits, syllabus, and prerequisites. Course offerings, including course number, year, semester, section number, instructor, timings and classroom. Students, including student-id, name, and program. Instructors, including identification number, name, department, and title. Furthermore, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an ER Diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.
A company makes items. Each item has a name, ID and component quantity. Every item contains many components. Each component can be supplied by one or more suppliers. Suppliers have names and IDS. Each component has ID, name, description, suppliers who supply them, and items in which they are used. Not all suppliers provide components, and a component is not always associated with a supplier. Also, a component always have to be associated with one or more items. Finally, the company contact customers using their IDs, Names and Phones to sell them items. A customer can buy one or more items.
Which of the following statements are true in the nursing home conceptual design as depicted by the EER diagram of the document above: Group of answer choices 1. Day Care and Resident have been conceptualised as disjoint Subclass Entity Sets of a more general class Patient 2. All entities known as Resident appear to have a specific relationship not applicable to Day Care entities 3. All entities known to the database as Patient must be classified either as Day Care or as Resident, or both. 4. All entities known to the database as Patient must be classified either as Day Care or as Resident
Draw an EER diagram to keep track of information for an art museum based on the following requirements a. The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique Id_no, an Artist (if known), a Year (when it was created, if known), a Title, and a Description. The art objects are categorized in several ways, as discussed below. b. ART_OBJECTS are categorized based on their type. There are three main types: PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types. c. A PAINTING has a Paint_type (oil, watercolor, etc.), the material on which it is Drawn_on (paper, canvas, wood, etc.), and Style (modern, abstract, etc.). d. A SCULPTURE or a statue has a Material from which it was created (wood, stone, etc.), Height, Weight, and Style. e. An art object in the OTHER category has a Type (print, photo, etc.) and Style. ART_OBJECTs are categorized as either PERMANENT_COLLECTION (objects that are…
B. Art Museum Database Draw an EER diagram to keep track of information for an art museum. Assume that the following requirements were collected: (10 marks) The museum has a collection of art objects. Each art object has a unique ID, a year (when it was created, if known), a title, and a description. Art objects must be categorized based on their type. There are three main types: painting, sculpture, plus another type called other to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is drawn on (paper, canvas, wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) And style. The museum keeps track of artist information, if known: name, date born (if known), date died (if not living), country of origin, epoch, main style, and…
In a database, an entity is a collection of characteristics. An entity might be a tangible thing that exists in our world.Each entity has an attribute, which in the real world is referred to as the object's characteristics. For instance, in a company's employment database, the individual, department, and classification may all be considered entities. These entities possess certain traits that will serve as the relevant entity's attributes.

SEE MORE QUESTIONS

Recommended textbooks for you

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

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

SEE MORE TEXTBOOKS