CCCS215 DB Project 2020-2021 Protected View Saved to this PC-
Search
File Home Insert Design Layout References Mailings Review View Help PROTECTED VIEW Be careful, files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Share Comments
Enable Editing
X
Part II. All DML commands for the population of each DB table; commands must be grouped by table to populate (Only Screenshots will be accepted)
Populate the tables with the following data:
Customers
CustID=001230 (choose a name and city as you like), type = pa
CustID=001231 (choose a name and city as you like), type = Co
CustID=001232 (your name, city as you like), type = p
CustID=001233 (choose a name and city = IFDDAH), type = P
Accounts
AccID=203040 (choose DateOpened, BalanceAmount, BalanceDate as you like), Currency = USD. Owned by Customer 001230
AccID=203041 (choose DateOpened, BalanceAmount, BalanceDate as you like), Currency = SAR. Owned by Customer 001231
AccID=203042 (choose DateOpened, BalanceAmount, BalanceDate as you like), Currency = SAR. Owned by Customer 001231
AccID=203043 (choose DateOpened, BalanceAmount, BalanceDate as you like), Currency = 'TND. Owned by Customer 001232
Transactions
TrID=10000 (choose Date and Amount from your own), performed on Account 203040
TrID=10001 (choose Date and Amount from your own), performed on Account 203041
TrID=10002 (choose Date and Amount from your own), performed on Account 203042
TrID=10003 (choose Date and Amount from your own), performed on Account 203043
TrID=10004 (choose Date and Amount from your own), performed on Account 203043
TrID=10005 (choose Date and Amount from your own), performed on Account 203042
Answer Part II here.
Page 3 of 7
Focus
100%
T
L
41%
ENG
7:37 PM 12/1/2022