University : Others UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : ISYS1055
Country : Australia

IT Assessment Task

Question 1. The Relational model

For the database, primary keys, and parent and child relations for foreign keys are annotated. The meaning of most attributes is self-explanatory. Answer questions below. Your answer to each question must  be according to the given database schema and instance.  

 

  1. Does the primary key  ensure that each customer orders a particular product? Explain your answer

  2. Can two products have the same

    product-no

    ? Can two products of the same order have the same

    product-no

    ? Explain your answer usingthe data integrity constraints on the

    Includes

    table

  3. It is possible that a customer does not make

    any product order

    ? Explain you answer.

     

  4. Can the below SQL statement be successfully executed? Explain your answer.

Question 2. Relational database design

  1. You are given the task to design a relational database to keep all information shown in Table 1. Note that Table 1 only contains sample data and your database will need to keep a lot more data. Give the schema for each relation in your database  and underline primary keys and put asterisk for foreign keys.  Justify your design for each relation. Your database must be able to answer the listed queries and any further queries on customers and their orders.

  2. Give the CREATE TABLE statement for each relation, including primary key and any foreign key constraints.

This IT Assessment has been solved by our IT experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Keith
  • Posted on : November 29th, 2018

Whatsapp Tap to ChatGet instant assistance