ICT285

Case study Chester Merrythought is pleased with your work so far and has asked you to go on to implement your design. However, like so many clients, she wants to make some changes to the requirements, some of which have become evident as the venture continues to grow in popularity.  Chester’s additional requirements are as follows: Chester has decided to move the toys in the ‘sports and activities’ category, currently housed on the ground floor o

15 Other / Other Murdoch University / ICT285 18 Nov 2020

Question 1: Relational algebra The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For

20 Other / Other Murdoch University / ICT285 18 Nov 2020

The assignment addresses the following learning outcomes for the unit:1. Demonstrate practical skills in using SQL2. Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF3. Create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches4. Explain and implement security as it applies in the database environment.

22 Other / Other Murdoch University / ICT285 18 Nov 2020

The assignment addresses the following learning outcomes for the unit: Demonstrate an understanding of relational database principles and theory Demonstrate practical skills in using SQL Demonstrate practical skills in data modelling using entity-relationship modelling Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF (partly)

18 Other / Other Murdoch University / ICT285 18 Nov 2020

The assignment addresses the following learning outcomes for the unit:1. Demonstrate practical skills in using SQL2. Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF3. Create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches4. Explain and implement security as it applies in the database environment.

22 Other / Other Murdoch University / ICT285 18 Nov 2020