2 please fast answer 1. Design ER Model for part of Internet sales system. The system provide thesales services for many customers to order many products from manycompanies. All Customers, products and companies information are stored inDB. Each customer can place one or more orders. The order can contain manyproducts that are supplied by one or more companies.2. Design ER Model for part of a Bank databases. The bank has multipleBranches, and each branch can have multiple accounts. Each customer can hasone account or more; or other services.3. Design ER Model for Hospital databases. Each Doctor is described by Doc ID,Phone, address, and specialization. Each doctor is allowed to work in only onedepartment. Each department is described by Dept no, Name, and issupervised by a doctor. Each patient is described by Card number, name,address, and phone. Each patient is assigned to one or more department. It'srequired to keep track each admission date. Each lab is described by LabNo,name. It's required to keep track any lab service that may be done to thepatient.4. Design ER Model for a library to manage data of books. The library containsbooks which are described by an ISBN, Title, Specialization. Each Book ispublished by one Publisher and written by many Authors. A publisher isdescribed by name, ID, Address, Fax and Phone number. An author isdescribed by name, ID, Address, Fax and Phone number. Each author writesmany books.

ANSWER ANS 1. The er 1 and er 2 is given below :-

Answered: please fast answer

Engineering

Computer Science

please fast answer

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter8: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

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.
Consider a database system for a Wholesale Management System. The data requirements are summarized as follows: o Maintain the details of stock like their id, name, quantity. o Maintain the details of buyers from which manager must buy the stock like buyer id, name, address, stock id to be bought. o Details of customers i.e. name, address, id. o Defaulters list of customers who have not paid their pending amount after the due date So List of payment paid or pending. o The stock that is to buy if quantity goes less than a particular amount. o Profit calculation for a month. o Quantity cannot be sold to a customer if the required amount is not present in stock and date of delivery should be maintained up to which stock can be provided. SQL Queries: 1. List of payment paid or pending customers. 2. Find the Defaulters list of customers who have not paid their pending amount. 3. Find the details of customers name, address, id. 4. Find Query to get information of employee where employee is…
Draw ER Diagram & Schema Diagram ================================ ER Diagram Description... During COVID-19 pandemic, it is not safe for the people to go out frequently for their daily needs. Similarly, people cannot live without their daily needs. ‘Online Sheba’ can minimize the suffering of people. ‘Online Sheba’ provides food delivery, emergency medicine delivery, laundry and grocery delivery. Besides, ‘Online Sheba’ provides courier services also. In this case, you have to build database management system for ‘Online Sheba’ to handle all the services it provides and to store all information related to ‘Online Sheba’ securely, like employee, customer, safety vehicle, shops, seller, receiver information. ‘Online Sheba’ provides few home services, food delivery, emergency medicine delivery, laundry, grocery delivery & courier service. Therefore, it must have few employees to initiate all the work. As COVID-19, safety issue is a very important factor; every employee must have a…
Draw a use-case diagram and create a set of activity diagrams for the following system. A Video Store (AVS) runs a series of fairly standard video stores. Before a video can be put on the shelf, it must be cataloged and entered into the video database. Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for three days at a time. Every time a customer rents a video, the system must ensure that they do not have any overdue videos. If so, the overdue videos must be returned and an overdue fee paid before customer can rent more videos. Likewise, if the customer has returned overdue videos, but has not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos. If a video is two or more days overdue, the manager calls the customer to remind them to return the video. If a video is returned in damaged condition, the manager removes it from the video…
What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them? There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students. In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the contents of the…
Q1: What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them? (a) There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students. ¬ (b) In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the…
Think of a bank that has several database locations.Assume that persistent messaging is the sole method available for the databases to interact. This database is distributed, right? Why?
A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.
Consider, for instance, the database management system that is used by an airline; such a system often has snapshot isolation as one of its many capabilities. I was hoping that you could provide me an example of a non-serializable execution that the airline is ready to endure in order to get better performance as a whole. If you could, that would be much appreciated.
Think of a database that would be needed at a professional service firm to maintain the contact list of clients/patients at the office of a CPA, attorney, or medical doctor. Identify the fields likely to be used in this database. If one person were constructing this database, how many spaces would it allow for each field?
The phrase "snapshot isolation" may be used to describe how a database for an airline can be created. If airlines can improve their overall performance, a system that cannot be serialized may be acceptable.
In the database role-based model, is it required that every application user must have a database account created? Also, In the application role-based model, is it required that every application user must have a database account created?