It's UWAweek 21 (1st semester, week 12)

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 166 articles.
Currently no other people reading this forum.


 UWA week 19 (1st semester, week 10) ↓
SVG not supported

Login to reply

👍?
helpful

###Hello, I have 2 main questions:

###Question 1: Discrepancies between the ERD and the text description. While doing the SQLite table code, I found out that some details are inconsistent between the ERD and the text description:

  • There is no mention of an email field and its data description for customers, even though it is present in ERD
  • In the text description, it can be assumed that the contact phone number would belong to table Client, however in the ERD it belongs under Customer
  • It is unclear whether details about who is paying for who would belong under Customer or Patient (although I assume this would be up to how we implement it)

###Question 2: Adding additional fields for entity identification and linking

Can we add additional fields for linking entities across tables (.ie between an appointment and its invoice)?

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  5:07AM Sep 06 2023
Privacy policy