Create a complete er diagram for the previous scenario

Assignment Help Computer Engineering

Reference no: EM133359828

Question: Bank Management System Database The Bank management system has a database that shows the relationships between the entities such as a Customer, Branch , and Loan_Application. Entities and Attributes a) Customer Entity: It has Customer ID, Name, Phone, City. b) Branch Entity: It has Branch Number, Branch Name, and Branch City c) Loan_Application Entity: It has Loan Number, Limited Required, Limited approved, and Date. b) Any Branch can have many Customers, but each customer is assigned to one branch. c) Each branch can manage many loans, as well as each loan is managed by many branch. Notice: Database should record the number of year to pay back the loan in the management relation.

1- Create a complete ER diagram for the previous scenario (Including all the requirements).

2- Map your ERD to Relation Model according to what you have learned in theory lectures.

Reference no: EM133359828

Questions Cloud

Proposed characteristics of authentic leadership complement : Discuss how the selected and proposed characteristics of authentic leadership complement each of the four primary components of authentic leadership

Information to select leadership theories : You will use this information to select leadership theories and approaches to support organizational change that aligns to your chosen organization's mission

Describe the positioning of best buy relative : Describe the positioning of Best Buy relative to its main competitors and Apply the VRIO framework to determine whether Best Buy has a competitive advantage

Describe in a justified manner and present future network : Describe in a justified manner and present the current network topology, network type (peer to peer and/ or server-based), and the topology components.

Create a complete er diagram for the previous scenario : Create a complete ER diagram for the previous scenario (Including all the requirements). Map your ERD to Relation Model according to what you have learned

Discuss how you can design an efficient distributed system : The three subsystems of a processor have different bandwidths, i.e., numbers of operations per unit of time, and latency, i.e., the time between the start

Create a view called itemorder this view must show tasks : Create a view called ItemOrder. This view must show Tasks.TaskID, Tasks.Description, Tasks.Price, OrderLine.OrderNum, WorkOrders. OrderDate, and OrderLine.

Are it applications an asset or an expense : MISY 673 University of Delaware Are IT applications an asset or an expense and What is the main purpose of allocating IT costs to user departments

Explain how your core values affect your perspective : identify the reading selection that most resonated with you and why outline and justify your perspective on whether grammar should play a role in hiring

User Account

All Pages