Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve the following sql problem and give an detailed explanation, Identify each important key such as primary and foreign keys. I will definitely give

Please solve the following sql problem and give an detailed explanation, Identify each important key such as primary and foreign keys. I will definitely give you helpful evaluation if you finished it, thank you!image text in transcribedI will definitely give you helpful evaluation if you finished it, thank you!

Project 1 Citibank Database 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 - Multi value - Composite - Derived - Keys - Primary - Foreign - Reduce duplication You must include at least 7 relations and at least four attributes for each relation. The relations will be in the format of: relation(attribute1, attribute2, attribute3). For instance, book(ISBN, title, author, price)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

More Books

Students also viewed these Databases questions

Question

6. What is the purpose of Tukey's HSD test?

Answered: 1 week ago