Given the following ER diagram. (1) How many tables should be created _(2) Translate the diagram into equivalent relational _schemas (table name, attributes, primary key and foreign key(s)). Date Туре Num Name --- Amount Account Transactions Has ISA balance BillPaid Chequing Account Saving Account

Given the following ER diagram. (1) How many tables should be created _(2) Translate the diagram into equivalent relational _schemas (table name, attributes, primary key and foreign key(s)). Date Туре Num Name --- Amount Account Transactions Has ISA balance BillPaid Chequing Account Saving Account

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

Question: Draw a diagram showing the relationships for all the tables. The following tables need to be modified as shown (primary key attributes are bold, foreign key attributes are in italics): CID in Retail and Wholesale are defined as a primary key and a foreign key. CUSTOMER (CID, Name, Address) PHONE (PhoneNumber, Description, CID) RETAIL (CID, Type) WHOLESALE (CID, ContractID) CONTRACT (ContractID, Description) OLDCONTRACT (ContractID, Description) ORDER (OID, OrderDate, CID) PRODUCT (PID, Name, Price) DIVISION (DID, Name, Address) LINEITEM (OID, PID, Quantity, AmountCharged) PRODUCTION (DID, PID, Quantity, Rating) One-to-one Relationship If the foreign key will be the primary key or part of the primary key, choose the Identifying Relationship 1:1 icon. Otherwise, choose the Non-Identifying Relationship 1:1 icon.
Discuss all aspects of database design. Discuss the diagrams used, the steps involved in the design and the design considerations.Your answer should be about 3 paragraphs.
Complete a database design for both the Invoice_printed and Real Estate Agent Listings problems / cases. Display your normalized tables as as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)
How do you determine the level of normalization required for a particular database design?
Create tables based on the below given relational model. Define your own data type to the attributes and apply your own constraints to the attributes Identify the primary, Hospital tables: patients (patient-id, name, insurance, date-admitted, date-checked-out) doctors (doctor-id, name, specialization) test (testid, testname, date, time, result)
Convert your ER diagram into relational database tables. List each table with all the fields, and identify the primary key and any foreign keys that exist.
Normalize the following given data to 1/2/3 NF. State the relations schema after everynormalization.