You are provided with the specification requirements below to implement a database management system (DBMS) for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
Based on the specification requirements provided for the Bank X database I will write the Data Defin... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
Diana is reviewing her portfolio of investments, which includes certain bonds and stocks. She has a large amount of her funds tied up in Government of Canada Treasury bills paying 5%. She is...
-
1. One argument that most people initially use against time dilation is the fact that you are not aware of it when you are moving. Complete the following calculations to help address this issue. (10...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What are the uses of performance appraisal?
-
Compute a 95% confidence interval for the population mean, based on the sample 10, 12, 13, 14, 15, 16, and 49. Change the number from 49 to 16 and recalculate the confidence interval. Using the...
-
Bergamo Bay's computer system generated the following trial balance on December 31, 2017. The company's manager knows something is wrong with the trial balance because it does not show any balance...
-
What is the most important feature of a driving point FRF?
-
A large company has hired your friend. She confides in you about a problem with her boss. Her boss has asked customers to sign sales agreements just before the end of the year, indicating a sale has...
-
Topic: Development of Inclusive Organizational Practices and Policies. Using a search engine or database, conduct your research considering the following: Leadership Recruitment Organizational...
-
AD Enterprise was established in June 2023. During the first month of the operation of the business, these events and transactions occurred: June 1 Mr. AD invested $100,000 cash in exchange into the...
-
How can we change the cultural narrative about rethinking? Can you imagine a world in which saying "I don't know" is seen as a mark of confident humility instead of ignorance and "I was wrong" is...
-
Scenario A theme park has a number of rides modelled by two classes: Ride and RollerCoaster. On a given ride each car has a capacity, and rides may be operational or not. A RollerCoaster is a ride...
-
Jay Lowe is a popular male singer. Top Hat Theatre in Jersey City, NJ wants to engage him for a one-night concert on June 1, 2021. Jay Lowe wants $500,000 for the concert. Top Hat does not have...
-
1 (a) Computation of profit or loss on the disposal of Delta Disposal proceeds Net assets at date of disposal (W1) Unimpaired goodwill at date of disposal (W2) Non-controlling interest at date of...
-
You and your friends are considering creating an electronic database that would contain all the information available to troubleshoot and repair every make and model of car from 2006 forward. The...
-
The multiplier for a futures contract on the stock-market index is $50. The maturity of the contract is one year, the current level of the index is 2,000, and the risk-free interest rate is 0.5% per...
-
1. Cinto Ltd. has furnished the following information regarding its current assets and current liabilities. Current Assets Cash Trade receivables Bills Receivable Inventory Prepaid Expenses Current...
-
Cost behavior and decisions Second City Airlines operates 35 scheduled round-trip flights each week between New York and Chicago. It charges a fixed one-way fare of $200 per passenger. Second City...
-
What are two essential elements in employee empowerment in MACS design?
-
What is the difference between flexible and capacity-related resources?
-
How are the identifiable assets and liabilities acquired in a business combination measured?
-
What is meant by deferred consideration and how is it accounted for?
-
Distinguish between a business combination and a non-business acquisition.
Study smarter with the SolutionInn App