For lab4, ques4, can anybody tell me the exact column name for job type in the bookjobs table

Hi Are the midsemester results out?

Hi, in the general specifications, it says for occurrences column in relationship data dictionary describe how the relationship exists in the organisation. How would that differ from what we write in entity relationship data dictionary?

We resolve many to many relationships usually by create a new relation (table). However, that is part of the logical modeling.

The first part of the unit outline show indicative weights that are in the handbook and do not change. From semester to semester, we change the weights slightly depending upon various factors (student feedback, performance of students, chatGPT etc.)....

I've had a look at the unit outline and theres a discrepancy with the weighting, in 1 part it says the project is worth 15 and in another part (further down) it says 20 . Anyway, my main question is, as there are 2 parts to the project, and a follow...

It is typically sufficient to connect the entities (tables) themselves.

Hi all, I am a bit confused as to how we resolve our many to many relationships. From what I can see we place a new Entity in between the two Entities in order to resolve it. In regards to the project does this mean we need new relationships between th...

When drawing an ER diagram, should only attributes from one table be connected to attributes from another table, or is it sufficient to simply connect the tables themselves?

I am having trouble to understand the questions too. In particular, the second part. In the given data (po items), IRN appears on the two rows as below 004 CCC IRN 4 006 GGG IRN 2 and IWS appears on one row as below 002 AAA IWS 2 In which situation, both...

Sounds like Chen notation. That's considered different to UML

When all else fails, I turn to my saviour Library Genesis (dont google LibGen, free books are bad mmkay).

ERD is not an SQL database 1 1. Pretty sure in the lectures they mention strong vs weak entities and the difference between them. That's what I thought was relevant to this line of questioning.

From my understanding, UML ERDs are not the same as database schemas; foreign keys are not explicit attributes, they are the database form of relationships in an entity relationship model. Each relationship in the ERM implies foreign keys. It's diffi...

I'm sorry, I still don't quite understand. I will give an example (without revealing too much about my ER diagram) If I have a relationship 'Makes' between Client and Booking, and I want the PK in the Booking table to include clientID, would I put 'c...

I think being a nominated driver does not constitute "doing business" with the company, nominated drivers are recorded as part of a vehicle hire transaction, only their information is recorded.

Dr. Nasim has provided some good samples of how to write these dictionaries in the slides on LMS.

So is the relationship name be like depot-vehicles?

Does being a nominated driver constitute as doing business with the company?

That is a good point, I didn't add in the check to make sure you need to use a sub-query, but it was a hint, and the question text didn't specifically say it HAD to be a sub-query, so use whatever works. One of the interesting things about SQL in gene...