02: Construct an E-R or UML diagram for the following SALES COMPANY database which has network ofsalespersons over all Iraqi cities:Customer(CustomerNo, CustomerName, SPNO, HQCity)CustomerEmpl(CustomerNo, EmployeeNo, EmpNamem, Title)Office(OfficeNo, City, Telephone, Ocize)Product(ProductNo, ProductName, UnitPrice)Sales(SPNO, ProductNo, Quantity )Salesperson(SPNO, SPName, CommisionPersentage, YearOfHire)

Actually, E-R is Entity Relation ship diagram

Answered: 2: Construct an E-R or UML diagram for…

Engineering

Computer Science

2: Construct an E-R or UML diagram for the following SALES COMPANY database which has network of

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

Relational Model (Logical and Physical Schema Development) The conceptual model developed in phase 2 will be transformed into a logical and physical schema using the relational data model. The outcome of this transformation will be a relational schema. The schema should have the following components: Set of required relations All the integrity constraints Submission and Evaluation: A report consisting of the problem statement, ER diagram, relational schema And implement the database using SQL should include: All the tables properly defined /created All constraints properly defined For each table, few instances of data should be entered. Producer Pharmacy medicines The pharmacy contains employees, certain medicines customers and patients Date Name Customers age pharmacy sex employees Commercial Record Address Location Salary Name
Design a conceptual schema (ER diagram) for doctors’ offices. The following information describes the situation that doctors’ offices database must model. Be sure to indicate all key and cardinality constraints and any assumptions you make. Each doctor has badgeId , and name. A doctor is uniquely identified by their badgeId and may manage more than one office. An office may be managed by at most one doctor. An office has address and a phone. it is uniquely identified by its address, and it contains one or more exam rooms An exam room can be identified by its room number, and the office that it is in. Each patient has SSN, name, and phone number. Patient is uniquely identified by their SSN. When a patient visits an office, he or she has a consultation with a doctor in an examination room.
What do you consider to be the four most important factors while developing software? Please comment on the extra four qualities you believe should be included in the software development process to improve performance.
LOGICAL DATABASE DESIGN The above EER-Diagram represents a University Library Membership (see Diagram 5). A member can borrow as many books from the library. Derive relations for logical model from the above EER-Diagram. Please identify any primary key or foreign key in the derive relations (if applicable).
Please written by computer source Part I - Modeling You are building a database for a comic book store customer management system. Given the database specification below, your job is to turn the specification into an ER diagram. Your notation must be consistent with the notation used in our lecture notes. You can use all constructs and notations discussed in our lecture notes and nothing else (i.e.. oven notations used in the textbooks but not in our lectures cannot be used). Your ER diagram should capture all the information and constraints in the specification but, at the same time, be minimal. It means that redundant entities, relationships, attributes and constraints should be avoided. You may use any drawing tool of your choice (for example, Dia, diagrams.net, Lucidchart, etc.) to draw your ER diagram. Hand drawings will not be accepted. Database Specification The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should…
Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…
"SUPERMARKET STOCK CONTROL SYSTEM" It is an application made for the employees in the Super Market to query the stock of the items more easily. Thanks to a single application, they will have information about the status of the items. According to the above information draw an E-R diagram (Specifiy all entities-relationships-attributes). Show (explain in detail) that the database is at least in 3rd NF.
Computer Science Relational Model (Logical and Physical Schema Development) The conceptual model developed in phase 2 will be transformed into a logical and physical schema using the relational data model. The outcome of this transformation will be a relational schema. The schema should have the following components: Set of required relations All the integrity constraints Submission and Evaluation: A report consisting of the problem statement, ER diagram, relational schema And implement the database using SQL should include: All the tables properly defined /created All constraints properly defined For each table, few instances of data should be entered.
Draw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.
Whenever time one object has the main key of another entity as an attribute, a Parent-Child relationship is established between the two databases. Assume a B Many-to-Many relationship between the tables. C The tables are represented as nodes in a network diagram. D The tables are related to one another in a many-to-one fashion.
Exercise 1The purpose of a disposal dishware company manager is to implement a data warehouse application to observe his activity of sales at the different stores located in different cities of his products. Each store is characterized by a type (according to its surface), an address and a city. The manager wants to know the number of products sold and the total amount for each sale by year, quarter, and month. Based on this description, design a data warehouse star schema for this company with full details regarding dimensions and fact tables.
With the following Object Oriented Relational Database schema, select the attributes that a tuple in Teachers would have. create type Person (ID varchar(20) primary key, name varchar(20), address varchar(20)) ref from(ID); create table people of Person; create table students ( degree varchar (20)) inherits people ;create table teachers ( salary integer ) inherits people ; a. id b. salary c. degree d. name