Database Lab (CE 450) ( Task 9) B) Objective: Design the Appropriate Database Schema for ER diagram: 1. Identify the tables for the Database. 2. Identify the columns for the tables. 3. Identify the...


Database Lab (CE 450)<br>( Task 9)<br>B) Objective: Design the Appropriate Database Schema for ER diagram:<br>1. Identify the tables for the Database.<br>2. Identify the columns for the tables.<br>3. Identify the constraints(PRIMARY KEY,UNIQUE,NOT NULL,FOREIGN KEY )<br>constraints for the columns.<br>An ER diagram for a BANK database schema<br>BRANCHES<br>BANK_BRANCH<br>BANK<br>Code<br>Name<br>Addr<br>Addr<br>Branch_no<br>АСCTS<br>LOANS<br>Acct_no<br>Balance<br>Loan_no<br>Amount<br>ACCOUNT<br>Туре<br>Туре<br>LOAN<br>M<br>A_C<br>LC<br>(Tname<br>Mname<br>Lname<br>Bdate<br>Ssn<br>Name<br>Age<br>Phones<br>CUSTOMER<br>Addr<br>

Extracted text: Database Lab (CE 450) ( Task 9) B) Objective: Design the Appropriate Database Schema for ER diagram: 1. Identify the tables for the Database. 2. Identify the columns for the tables. 3. Identify the constraints(PRIMARY KEY,UNIQUE,NOT NULL,FOREIGN KEY ) constraints for the columns. An ER diagram for a BANK database schema BRANCHES BANK_BRANCH BANK Code Name Addr Addr Branch_no АСCTS LOANS Acct_no Balance Loan_no Amount ACCOUNT Туре Туре LOAN M A_C LC (Tname Mname Lname Bdate Ssn Name Age Phones CUSTOMER Addr

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?