tut2.docx - ITECH 1103 BIG DATA AND ANALYTICS Tutorial 2...

This preview shows page 1 - 3 out of 7 pages.

ITECH 1103 BIG DATA AND ANALYTICSTutorial 2TopicEntity Relationship Modelling Review Questions1.Identify issues in the Crow’s Foot notations used in the following ERD.2.Lucidchart - this product is a browser based diagramming tool; it is able to draw awide range of different diagrams, including ER Diagrams. As a University student youare entitled to a free Lucidchart account.You can sign up for the free account usingyour university email address. When your account is created and an invitation emailsent to your FedUni student account (check Spam if the message is not in yourinBox). Click on the link in your Lucidchart welcome email and you will be able tomake use of the software. As a first step you should look at the provided tutorials, inparticular "Entity RelationshipDiagrams".To prepare conceptual models (ERDs), you may use Lucidchart or any other drawingpackage.Page 1of 7
3.Given a scenario represented by the following entities, where customers place ordersfor products:CUSTOMER - customer number, name, address, phone numberORDER - order number, order date, customer number and for each product orderedthe quantity ordered and the total line price PRODUCT - product number, product description and product unit price An initial ERD using Lucidchart for this scenario would be the following: This ERD only shows the primary keys of each of the entities, sometimes an ERD isdrawn such that it will show all the non-primary key attributes for the model. In such acomplete ERD you must not show or label foreign keys

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture