It's UWAweek 47

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 the 4 articles in this topic
Showing 4 of 684 articles.
Currently 135 other people reading this forum.


 UWA week 36 (2nd semester, mid-semester break) ↓
SVG not supported

Login to reply

👍?
helpful
3:15pm Wed 4th Sep, James S.

What I found missing from the case study is billing or POS (Point of Sale) which would draw data from the different tables to produce a final invoice. All the information is recorded. Do we need to worry about an invoice/cash receipt table for instance? I am thinking from a process point of view that this data would be mined for billing purposes.


SVG not supported

Login to reply

👍?
helpful
8:08pm Thu 5th Sep, Mengxi L.

I think it’s great that you are considering the billing and invoicing aspect. It makes sense to include an invoice or billing table to link all the relevant data together (e.g., client, vehicle, tariffs, number of days hired, insurance details),which is often a critical business need for tracking payments and managing accounts.You can add it to your design and explain this assumption in the optional assumption document that the project allows.


SVG not supported

Login to reply

👍?
helpful
2:10pm Fri 6th Sep, James S.

If it is not required then I am not going to put it in. I guess I was just thinking about it from a business perspective and I thought, is this the missing link? That leads to a HD? The obvious one that we need to put it. Point of Sale I guess is the most crucial part of the whole model, but you have confirmed that it is optional.


 UWA week 37 (2nd semester, week 7) ↓
SVG not supported

Login to reply

👍?
helpful
10:20am Tue 10th Sep, Mehwish N.

Yes, that is a very good point! Though you do not have to include invoice right now, in the second part, I'll show that business requirements can change and suddenly the client realises that they have missed some requirements. Invoice is coming in part 2. Also, note it is a good thing to ponder over missing entities, but also keep in mind that you need to work within the scope of the case study :D

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  8:08AM Aug 25 2024
Privacy policy