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.
Hi, I actually found some discrepacies and missing information I would like to discuss, I hope this will reach the teaching team to help me and other students to do their projects.
Below I have grouped the questions according to the entity for ease of reading.
CLIENT:
1. From the case study narration provided there is this sentence of "and one or two email address (S 20) are recorded along with a generated unique client identifier". However the ERD for client only have phone[1..2] and does not specify email[1..2]. Should we still add the email to the logical model (following narration) or should we ignore the email and just follow the ERD?
2. As for this "generated unique client identifier" are we free to use any data type or there are certain data types we have to adhere to?
3. Seems like the erd is wrong for client address (address as the header of composite values should not be indented right?)
4. How about company name? narration does not provide the type for it, are we allowed to assume the length on out own?
VEHICLE TYPE:
5. Model data type and length is not specified for Vehicle Type, which should we use then?
6. What should we fill in Doors, Body and Trim? it is not specified in the narration.
7. As for Fuel can we fill it with S(6) since it is mentioned in narration that it can be (EV, Hybrid, Fuel)? or Fuel here refers to something like "Gasoline" and "Diesel"?
VEHICLE:
8. Same with question 1, Vehicle ERD does not have phone number. Should I still follow narration and add it or just ignore it and follow ERD?
INSURANCE:
9. InsuranceID and PolicyType does not have data type in narration, what data type should we use? Are we allowed to assume on our own?
POLICY NUMBER:
10. Policy number does not have any data type mentioned in narration, what data type should we use? Are we allowed to assume on our own?
HIRED VEHICLE:
11. If I think that Date and Days is a dangerous column name to use in SQLite (it may be used as function or method in other sql languages), are we allowed to rename it to something like startDate and hireDays for clarity?
OTHER MISC QUESTION:
12. If I believe that making new single primary key field is better instead of using multiple fields for composite keys (of course it will be recorded in the assumption pdf), am I free to choose whatever data type I use for this?