Make sure that create 3NF Table. A bank has many branches, with many customers. A customer can open many different kinds of accounts with the bank. Any customer of the bank can take loan from the bank. All branches can giv loans. Banks have also installed automatic teller machines, from which a customer can withdraw from his/her bank. Draw the ER-diagram for the bank specifying aggregation, generalization or specialization hierarchy, if any. Create 3NF tables of your design. Make suitable assumptions if any.

Make sure that create 3NF Table. A bank has many branches, with many customers. A customer can open many different kinds of accounts with the bank. Any customer of the bank can take loan from the bank. All branches can giv loans. Banks have also installed automatic teller machines, from which a customer can withdraw from his/her bank. Draw the ER-diagram for the bank specifying aggregation, generalization or specialization hierarchy, if any. Create 3NF tables of your design. Make suitable assumptions if any.

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

Task #1 – Identification of dependencies We learned about two types of functional dependencies, Partial Dependency and Transitive Dependency, and they are critical clues for the identification of tables. In this task, we will practice how to identify the two types of dependencies, so that we can improve the results to new tables. Below is a list of attributes of a dataset. However, the attributes still have some functional dependencies, which means you can create more tables by separating some field(s). Order_ No Product_ No Product_ Description Product_ UnitPrice Customer_No Customer_ Phone Customer_ Address Order_ Date Shipping_ Address Order_ Qty Which partial dependency does this dataset have? Identify the partial dependency using the format in the example below. Example) Partial Dependencies: (ProjectNum ? Proj_Name) (Emp_Num ? Emp_Name, Job_Class) Then, which transitive dependencies does this dataset have? Identify the transitive dependencies…
Answer in Sql - ER diagram in database tables.
Describe how functional dependencies may be used to show: • There is a many-to-one connection set between the entity sets student and instructor, as well as a one-to-one relationship set between the two.
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
build an entry relationship diagram using the data provided. example of graph included.