for part of a BANK database. Consider the ER diagram shown in . Each bank can have multiple branches, and each branch can have multiple accounts and loans. a. List the strong (nonweak) entity types in the ER diagram. b. Is there a weak entity type? If so, give its name, partial key, and identify- ing relationship. c. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram? d. List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify vour choices.

for part of a BANK database. Consider the ER diagram shown in . Each bank can have multiple branches, and each branch can have multiple accounts and loans. a. List the strong (nonweak) entity types in the ER diagram. b. Is there a weak entity type? If so, give its name, partial key, and identify- ing relationship. c. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram? d. List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify vour choices.

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

Design an entity–relationship diagram for this database. Identify primary keys and relationship cardinalities using(min:max)notation. If you make any assumptions, please state them clearly.
d Cônceptual design In the refarional model, the database snapshot is also called Select one a Current set of entity b.current set of entity C. Current set of objects d. current set of instances In dagams the nart par
Write the short answers for the given question. Answer in 3-5 line maximum. A. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. Why? B. Why do we need mappings among schema levels? How do different schema definition languages support this architecture? C. Under what conditions can an attribute of a binary relationship type be migrated to become an attribute of one of the participating entity types? D. List any 2 cases where the use of a null value would be appropriate.
MIS150 hires qualified employees to purchase merchandises from vendors. Develop an appropriate enhanced entity relationship diagram for MIS 150 database that only describes MIS 150 employees to purchase merchandises from vendors for increasing inventory, and to handle purchasing payments for the vendors that could be either credit and/or cash. The diagram can only have one-to-many relationship and cannot contain any irrelevant entities to avoid points deduction. (Use Word’s Shapes, and Text Box to draw enhanced entity relationship diagram
Database Systems, Do the database er diagram and answer part D
The following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram. 1. Indicate the changes you need to make to the design of the BITS database to support the following situation. A client is not necessarily represented by a single consultant but can be represented by several consultants.
You have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…
Hi there, Please answer this four question together. Thanks for your quick response in Adance as usuall. please find the attached question below. Best
A public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities. A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward…
Subject: DatabaseIdentify ALL errors and correction on the entity relationship diagram (ERD) given in Figure 5.i. Circle the errors identified on the diagram.ii. For each error identified, correct them. Show your corrections either by redrawing the corrected diagram OR by describing how the errors should be corrected next to the circles that you have identified.
Write the short answers for the given question. Answer in 3-5 line maximuт. A. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. Why? B. Why do we need mappings among schema levels? How do different schema definition languages support this architecture? C. Under what conditions can an attribute of a binary relationship type be migrated to become an attribute of one of the participating entity types? D. List any 2 cases where the use of a null value would be appropriate.
All of you must be familier with human resources system (employee database). Soplease design database for a human resources system that at least has 4 entitiesinvolved and for the 4 entities please do the following:a. Create the tables that conform to 3NF.b. Draw the Crow’s Foot ERD to reflect the dependency and relationshipdiagrams;c. For all entities/tables created please write the MASTER and TRANSACTIONdata accordingly!d. Use SQL commands to to do selection which involve 1 table, 2 tables, and 3tables.