In my point of view, One Room can be associated with only one Lease at a time since a room can only be assigned to one student at a time (for the semester). Lease document is a legal document and only one lease agreement can be valid during a time. h...

Hi, After DROP, INSERT (some sample data), the project requires to "perform some simple queries to ensure it works correctly". So, what kind of queries are they and do they need to be listed in the SQLite script submission file? Are Views and Triggers...

Hi, I just went through the mid terms answer sheet and 1 mark needs to be added to my final grade as answers a and e are both correct. However, I am unable to fill the form supplied as I submitted a response before and only 1 response is allowed per ...

I have the same question.

Same here.

Hey I am facing the same problem.

Hi, where did you find the answers? I want to compare my result.

in announcement.

Hello all, Does anyone know where the form to enquire is? Thanks

Oh, you made me to compare mine and I also lost 2 marks. No idea what to do...

It's because the Staff table has a BranchID value D200 which is not present in the Branch table. So referential integrity is violated.

For Question 8 of the Mid Semester Test. Why is the answer e and not c? Entity integrity was violated since StaffID wouldn't be uniquely identifiable by the Null value. But surely referential integrity wasn't violated, since StaffID isn't used as a fore...

Same here, 2 marks lower

Same here my marks should go up but now the form is unavailable. What should I do?

Hi all, I just compared my answers against the result of the Mid-term exam, and I found that my mark on the system was 2 marks lower. Is there anyone who has the same problem as me or just my issue? I've already submitted a form to ask about my mark,...

Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) hotelNo, hotelName( price 50(Room)) The correct option given for this is b) This ...

Hi, I believe the mark I received on CSmarks are also lower than what I actually would have got comparing my answers to those on LMS, by 3 marks.

It has been uploaded. However, according to this answer sheet, my marks should have been 2 marks higher than what I received. Did you receive the right mark according to this answer sheet?

In the ERD there are two 1 many relationships between HiredVehicle and Depot (Picks up at and Returns to). In 1 many relationships we add the PK of parent entity into child entity as FK. So do we add DepotID (PK of parent entity) into FK of HiredVehi...

If I need some more Associative Tables (which are not drawn in the ERD) for 2 or 3 entities, it is possible for this Part 2? In addition, is driversNum written in PersonalClient license number or quantity? Thank you and best regards.