Question
2.2) (2 Points) Devise a reasonable database instance by filling the tables with reasonable data of your choice. Make sure to have at least 3
2.2) (2 Points) Devise a reasonable database instance by filling the tables with reasonable data of your choice. Make sure to have at least 3 tuples in each table. Make sure that all tables exhibits entity integrity and referential integrity constraints.
Branch
branchName | street | city |
Golden Valley | Berkshire ln | Golden Valley |
Plymouth | Nathan Ave | Plymouth |
Normandale | 98th St | Bloomington |
Account
accountNum | branchName | balance |
132873 | Plymouth | 100029 |
132874 | Normandale | 30481 |
132882 | Golden Valley | 204 |
Customer
customerSSN | street | city |
321546543 | Nathan Ave | Plymouth |
472924857 | Berkshire ln | Golden Valley |
89683046 | 98th St | Bloomington |
Deposit
customerSSN | accountNum | amount |
321546543 | 132873 | 239 |
472924857 | 132874 | 4675 |
89683046 | 132882 | 10 |
2.3) (2 Points) Write an SQL statement to decrease the amount of all deposits by 1%
2.4) (2 Points) Write a SQL statement to increase by 5% the balance of all accounts that are created in a branch with name Golden Valley
2.5) (1 Points) Write an SQL statement to select all Customers SSNs where the city has a null value
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started