Week 2 Practical work

Week 2 Practical work - Week 2 Practical work Section 3...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Week 2 Practical work 1. Section 3 Type "A" problems: Creating an Entity- Relationship Diagram from a Relational Data Model A1 - Newsagent A2 - Cafe Menu A3 - Students and Subjects A4 Salesmen SALESPERSON SalesID SalesName BirthDate Salary 99101 Abel 05/06/1956 120,000 99102 Baker 11/06/1938 42,000 99103 Jones 26/12/1975 36,000 99105 Murphy 14/03/1958 50,000 99107 Zenith 31/01/1950 118,000 99108 Kobad 27/03/1980 34,000 ORDER OrderNo CustID SalesID Amount 100 A111 99107 500 200 A111 99103 1,800 300 A122 99101 480 400 A125 99101 2,500 500 A111 99105 6,000 600 A126 99101 700 700 A122 99103 150 CUSTOMER CustID CustName City IndustryType A111 Abernathy Constructions Wagga B A122 Manchester Lumber Manchester F A125 Amalgamated Housing Bathurst B A126 Tri-City Constructions Vittoria B
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
A6 Thirlemere Thoroughbreds Thirlemere Thoroughbreds is a family owned stud farm that breeds show horses. SHOW
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

Week 2 Practical work - Week 2 Practical work Section 3...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online