1 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.

services for many customers to order many products from anies. All Customers, products and companies information are ach customer can place one or more orders. The order can conta ets that are supplied by one or more companies. n ER Model for part of a Bank databases. The bank has hes and each branch can have multinle accounts Fach custome

services for many customers to order many products from anies. All Customers, products and companies information are ach customer can place one or more orders. The order can conta ets that are supplied by one or more companies. n ER Model for part of a Bank databases. The bank has hes and each branch can have multinle accounts Fach custome

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

Specification Suppose you are asked to design a club database system based on the _following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees. Question Draw an E-R diagram for the system according to the above description.
Cinmaplex is a large library that borrows books to all members in the society. This library needs to maintain a record of its members and borrowed books in a database. The details about members need to be stored including member identification number, member name, telephone number and address. The details of available books are stored in the database. The database should contain a unique identification number for each book, book title, book rating and number of copies. As books are rented, transactions are recorded. Every transaction records an invoice number is automatically generated, schedule, date of return, actual date of return and final amount if required. Use Ms Access to create the entities and attributes identified in the case study. Hint: Make sure all tables are normalized.
A cormpany has a single table in a computer (e.g., a spreadsheet) in which is stored every information abow each worker including the transactions he/she does in the company. This,table is A A table database B A spreadsheet CA flat file database •D A joint database
A university wants to develop a database system to manage student enrollment and course registration. They need an ERD to represent the key entities and their relationships. Entities: Student: Each student has a unique student ID, a name, a date of birth, and an email address. Course: Each course has a unique course code, a title, a description, and the number of credits. Enrollment: Each enrollment represents a student's registration in a specific course for a particular semester. It includes information about the grade received for that course. Professor: Each professor has a unique professor ID, a name, and an email address. Professors teach one or more courses. Create an ERD that represents the relationships between these entities. Include Entity name, attributes, identify Primary and Foreign key and crow foot relationships.
Project Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…
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…
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.
Create an ER diagram for the following requirements:You are asked to design a database to store music album information. A simplified set of requirementsare provided below.- A music album has a title, year of release, total running time, one or more artists, and list ofsongs.- Each song has a lead artist and may have a list of additional artists. Each song has a list of otherassociated people such as mixer, mix engineer, keyboards, guitar, etc. Each song has a genre,running time, and lyrics. Each song can be associated with many albums, but needs to beassociated with at least one.- Each person has a first name, last name, and nickname.
In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Product
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.
Take, for example, a database that is used by a large airline and in which the underlying database management system utilises snapshot isolation. In spite of the fact that the airline would prefer a serializable execution, it could be ready to tolerate a non serializable execution if it means that the process would be completed more quickly overall.
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?