- 0 Has Shopping Cart Cartid Productid Quantity Dateadded Addcartitem Updatequality Viewcartdetails 1 (36.26 KiB) Viewed 34 times
If using Postgres rather than Oracle then type inheritance doesnot exist so instead, they should use table inheritance, and nestedtables do not exist but arrays do.
They need to ensure tables are dropped (normally in reverseorder) before they are created.
Then they should create types, then tables (using types whererelevant). Also check attribute data types to check they aresensible (e.g. suitable sizes/precision for the data required), andthat they are using varchar for data such as telephone numberswhich can start with 0. Also that they include use of atimestamp/date/interval which they can then use in task 4. Also,it’s better to use NUMBER/NUMERIC than INT so they can specificprecision (check that the precision stated is sensible, i.e. theydon’t just use the same size for each attribute).
Check they have sufficient data, not looking for a lot of data,a few rows for each table, and that for example numeric data isn’tin quotes, and they’ve used null, not ‘’. They also need somesort of numeric data so that they can use this in their OLAP queryin task 4 – so check that they have something suitable forthis. Also, if they have data such as an address, it shouldbe split into separate fields (street, town, etc.) or preferablythey could use a complex type.
They should provide evidence that their script works in the PDFdocument they provide, and they should also provide a completescript file in a .sql file. Check that they that have writtenthe code themselves and it’s not code that’s been automated byOracle/PostgreSQL. If so, then the max mark is Majorissues.
0..* has Shopping Cart + cartid + productID + quantity + dateAdded + addCartItem() + updateQuality() + viewCartDetails() + checkOut() 1 Customer + customerName + address + email + credit Card Info + shippingInfo + accountBalance + register() + login() + updateProvile() 1 place 0..* Order + orderld + date Created + dateShipped + customerName + customerld + status + shippingld + placeOrder() -register. has User + userld +password + loginStatus + registerDate + verifyLogin() -has a- Shipping + shippingld + shipping Type + shipping Cost + shippingRegionld + updateShippingInfo() 1 Administrator + adminName + email + updateCatalog() Product + orderld + productid + productName + quantity + unitCost + sub Total + calcPrice()