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

What is a key feature of fourth normal form? It breaks tables down into as many tables as possible to avoid redundancy. It creates multivalued dependencies. It is focused on eliminating join dependencies. It should already satisfy the properties of BCNF.
Create an ERD using Visio or any other tool for the following scenario. Your ERD should show all the tables, attributes for each table and identify all primary and foreign keys. A hair salon has many customers and many stylists - the first name, last name, and phone number need to be stored for customers and stylists. The hair salon offers many services - hair cutting, styling, coloring, permanents, etc. Each service has a cost and the estimated time. Customers schedule appointments with a stylist. The appointment can consist of one or more than one service - i.e. a person may want a hair cut and coloring. Some customers purchase products at their appointments. A product has a brand, description, category and price. Please show all work and the finished diagram. Thank you!
I need crow's foot diagram for my ms sql server hospital database project. I add the business rules and the assets I created below. Business Rules A patient can only visit a doctor.A doctor can examine many patients. An examination can be done by a doctor.A doctor can do multiple exams.A patient can request more than one exam from the doctor. Each staff member can only have one title.Some staff members may not have a title. A hospital can employ more than one doctorA doctor can work in a single hospital. A patient can give more than one test.Each assay can only be given by one patient. A prescription is for one patient only.A patient may have more than one prescription. It can contain many drugs in one prescription.The same medicine can be prescribed in many prescriptions. Only one patient can stay in a ward.More than one patient can stay in each room.A patient can stay in only one room. By the way, Please alert me if you think I have made the relational diagram wrong. I'm so grateful…
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…
If you sell a house more than once, it is treated as different "property" for each sale. Draw an entity-relationship diagram and write a database design outline. Q2. Law Office: You are trying to automate the records for your uncle's law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). Each attorney has multiple cases, which is identified by a unique "docket number". Each case has a name and description, is worked on by only one attorney, and involves a single client. For each client, you want to store a first name, last name, middle name, phone number, address, city, state, and zip code (assume you do not have a zip-code table). Finally, you want to keep track of the billable hours spent on each case. For a single case, this comprises information that looks like Hours Billed Date 2/24/2005 Description Prepare brief…
Consider a PUBLICATION COMPANY database in which data requirements are summarized as follows: Every topic should contain name, code and research area. The topics can have several reports and the reports may contain several topics in them. The report should have a title. A department can publish more than one report. A report can be published only by a single department. The department must have its name and address. Reports can be written by many contractors and contractors can write many reports. Each contractor should have name and address. A publication can include several topics and a topic can be present in more than one publications. A publication must have its title and code. One department can have many publications and a publication can be made only by one department. Construct an E-R diagram (based on a Chen's model) to represent the above requirements. Make sure you include all appropriate entities, relationships, attributes, and cardinalities.
Given the database schema with the following relations: STUDENT (id_stud, name_stud) LECTURER (id_lect, name_lect) SUBJECT (id_subject, id_lect, name_subject, credits, id_room) ROOM (id_room, no_room) ENROLL (id_stud, id_subject) Create an algebraic relation for: a. Displays all names of lecturers who teach the subject with a total of 4 credits b. Displays all no_room with the student name "Eko" c. Displays all data in the form of student id, student name, name of the course followed and the name of the lecturer who taught the subject name "Database" From the database schema and the questions above, create an appropriate SQL query for each of these statements above.
Draw the ERD of the database that could be used to support the operations of the business described in the case Business Case: Bike with Us • Bike with Us is a bicycle rental company which has several offices in different neighborhoods of Montreal. Each office is identified by a Station_Code and its geographical location (i.e., latitude and longitude). • Each office is assigned one or more employees for different tasks. Attributes of employees include Employee_ID and Employee_Name. An employee must be assigned to only one rental office. • For each office, there is always one employee assigned to check bicycle conditions. • The office rents several classes of bicycles: road, mountain, electric bike, touring, folding, fixed gear. Each bicycle is managed by one office. Customers might rent bicycles from different offices in the city. • Bicycles are to be described by data such as: make, year of production, uses (purpose), size, registry number, purchase price, purchase date, rent…
Suppose that the initial conceptual design of the Car Rental database consisted of just a single relation as follows:Rental(VehicleID, CustomerID, DateOut(PK), DateReturned, VehicleClass, RentalRate, CustomerFName, CustomerLName, Balance) Normalize the Rental relation to 2NF and 3NF
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.…
An entity student has a derived attribute "age". When mapping ER Diagram to schema, you place attribute "age" in Select one: O a. In a table that is connected with student by a relationship O b. table student O c. Derived attributes are not allwed to be stored in database tables O d. In a separate table
Please read this carefully and Draw an EER diagram for a database of a hospital following these requirements: create Four to five regular strong entities. A union One 1:1, one 1:N, and one N:M relationship – of which at least one relationship should be partial and one full. One overlap relationship and one disjoint relationship. Other notes: Do not emphasize on too many attributes for the entities. Two to three attributes for each entity will be enough. Make sure to include a primary key for each entity.