INF1002 ass And Credit Assessment

Pass 5a

Read the following narrative:

Petes 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.

• Paste your answer into the document named T05P.DOCX