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,
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...
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.
According to the hint "Hint use UNION then an EXCEPT operation."
But why? Because the table bookjobs has both cust id and jobtype, we just need to use EXCEPT like this
SELECT cust id
FROM bookjobs
WHERE jobtype IN ('R', 'H')
EXCEPT
SELECT cust id
FROM boo...
Cool,
I know the logic may decide whether a given relation is the correct or not but I may not write down those things by myself because they are so hard to remember their names or symbols or drawings, etc.
Thank you.
Dear,
In week 3, we have learnt about Relational Algebra such as selection, projection, etc.
Do we have to remember how to write the relations using those symbols operations (U, up-side-down U, big Pi, sigma, etc..) or we just need to focus on SQL quer...