The ORDER data set $($i$.$e$.,$ table$)$ described below contains data about orders and their

associated line items. In other words, Order$\_$no $134$ has one line item, Order$\_$no $135$ has

two line items, etc. The combination of $($Order$\_$No$,$ Part$\_$No$)$ is used to identify each line

item.

ORDER $($Order$\_$No$,$ Date, Part$\_$No$,$ Number$\_$ordered$)$

Order$\_$No Date Part$\_$No Number$\_$ordered

$13401/22/22$ AX$1311$

$13501/22/22$ BT$041$

$13501/22/22$ BZ$661$

$13601/24/22$ CB$034$

$13701/25/22$ CX$112$

$13801/25/22$ AZ$522$

$13801/25/22$ BT$042$

$1.$ Suppose it is necessary to change the date of order $135.$ What is required to make this

change $($i$.$e$.,$ in general how many rows need to have the date changed$)?$

$2.$ Suppose a table were to be created for the ORDER data set given in question $1.$

a$.$ How many rows would be added to the SysTables data dictionary table discussed in class

$($also known in Oracle as the ALL$\_$TABLES data dictionary table$)?$

b$.$ How many rows would be added to the SysColumns data dictionary table discussed in

class $($also known in Oracle as the ALL$\_$TAB$\_$COLUMNS data dictionary table$)?$