diff_months: 20

INF1002 ass And Credit Assessment

Download Solution Now
Added on: 2022-11-09 07:07:32
Order Code: :475129
Question Task Id: 0
  • Subject Code :

    INF1002

  • Country :

    Australia

Pass 5a

Read the following narrative:

Pete’s Pools have a number of swimming centres. Each centre has a name, establishment date, and a description. Clients (who have an ID and name) can join one or more of these swimming centres. As a client joins a centre, the date that the client joined is to be recorded.

  • Draw an ERD based on this case study. Fully expand all M:M relationships into M:1 relationships. Do not introduce any surrogate keys. The ERD may be neatly hand drawn or can be created in a package such as Visio or draw.io. The symbols in the ERD must conform to the symbols used throughout all ERD lectures this semester. Clearly indicate strong and/or weak entities, all identifiers and all relationship names.
  • Scan, Photograph or take a screenshot of the ERD and place it in the document named

T05P.DOCX

Pass 5b
  • Convert the ERD that you created in Pass 5a into a Relational Schema.
  • Copy and paste the relational schema and place it in the document named T05P.DOCX
Pass 5c
  • Using the Relational Schema you created in Pass 5b write the DDL Create Table statements for each Relation.
  • Copy and paste the code into the document named T05P.DOCX

Pass 5d

  • Explain what is meant by Normalisation.
  • Paste your answer into the document named T05P.DOCX

Pass 5e

  • The table below is unnormalised. Replace the table by data presented in 1NF.

CustId

Name

Phone

CarRego

MakeModel

StartDate

ReturnDate

125

John Coles

0401112233

1AU8HK

1LM3AB

Mazda 3 Hyundai i30

31/08/2020

14/11/2020

7/09/2020

21/11/2020

278

Erin Trump

0466121455

1AU8HK

1KA2CA

1CZ8JK

1AU8HK

Mazda 3 Toyota Camry Mazda 3

Mazda 3

12/09/2020

1/10/2020

10/11/2020

26/11/2020

19/09/2020

8/10/2020

12/11/2020

1/12/2020

721

Emma Knox

0423544117

1LM3AB

Hyundai i30

10/09/2020

13/09/2020

 

  • Paste your answer into the document named T05P.DOCX

 

  • Uploaded By : Katthy Wills
  • Posted on : November 09th, 2022
  • Downloads : 0
  • Views : 221

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more