Question: You are provided with the specification requirements below to implement a database management system (DBMS) for Bank X to store details about their Branches,
You are provided with the specification requirements below to implement a database management system (DBMS) for "Bank X" to store details about their Branches, Accounts, and Customers. SR-1: A BRANCH has a Brensbip that is numeric, a Branch Name, and Branch Address. The Brenship is unique for each branch while Branch Name and Branch Address may not be unique. SR-2: An ACCOUNT has an Account No field in numeric characters, Account Type, and Balance. The ACCOUNT_TYPE is either Savings, Checking, Credit Card, or Mortgage. The Account is unique for each account. SR-3: CUSTOMER has an SSN field that is of numeric characters, along with Name, Phone, Address. SR-4: A Branch has multiple accounts linked to it, while an account can be linked to just one branch. A customer can possess no more than 4 accounts in the same branch but of different account types. While accounts are not shared between customers. A customer can have multiple accounts in different branches. Only the customer's phone number may be empty (NULL), all fields in the database are mandatory. SR-5: SR-6: SR-7: 3. Using SQL, write Data Definition Language (DDL) commands to set up the database schema with the below tables. Note: Include a primary key for each table: a. BRANCH (Brenship. BrenshName, Brensbaddress) b. ACCOUNT (ASSINA, AssTypeID, Branch, SSN, Balance) C. ACCOUNT_TYPE (ASSTYRSIP. AccountTYRS) d. CUSTOMER (SSN, Name, Phone, Address)
Step by Step Solution
3.41 Rating (157 Votes )
There are 3 Steps involved in it
Based on the specification requirements provided for the Bank X database I will write the Data Defin... View full answer
Get step-by-step solutions from verified subject matter experts
