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
Get step-by-step solutions from verified subject matter experts
