Question: Please solve the following sql problem and give an detailed explanation, Identify each important key such as primary and foreign keys in a image. I
Please solve the following sql problem and give an detailed explanation, Identify each important key such as primary and foreign keys in a image. I will definitely give you helpful evaluation if you finished it, thank you!
Oitibank Database Important Dates - Due Date: March 1, 2023 - Cutoff Date: March 6, 2023 - Projects are submitted on or before the due date. - No projects will be accepted after the cutoff date. - 5 points will be deducted for each calendar day a project is submitted after the due date. Objective - Design a database for Citibank to manage customer accounts and transactions. - Create searches and output using relational algebra. Your database will have the following requirements. - Accounts have many characteristics, such as the type of account (checking, savings, CD, car loan, etc.), balance, owner of the account, when the account was opened, when the account was closed. - Customers have a name, address, social security number and at least 2 additional forms of ID (password, driver's license, birth certificate, etc.). - An account can have more than 1 owner. Customers own accounts. - Customers can perform transactions on accounts (deposits and withdrawals). - Transactions are performed at bank branches, ATM's or online. - Customers can assign ratings to bank staff. - Staff has many characteristics such as name, address, title, salary and branch assignment. Staff can be assigned to more than 1 branch. Identify or create the following. - Attributes - Cardinality - Degree - Domains - Keys - Relations - Tuples - Attributes - Single value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
