assignment 1 is hard

hi

iv started assignment 1 and its alittle tricky. has anyone got there yet?

anyone have a clue what they are going on about in quesiton 1.4??

nicola

still waiting for textbook

i got fed up with the JHB booksellers, they are realy useless!!!! i went to da book seller in hatfield and walked in and got all my books, including the specs one that has so few students. piece of cake.

Hi basically what they are saying is... if you make sid and did not null in the managers table - would that mean you could force each department to have a manager - the answer is no, because if you make those fields not null then you can put a value "No manager" in it (example), this does not mean then that you are actually saying each dept has a manager. You have to have a foreign key on did and sid so that those columns have values from the employee and dept tables.

ssn – Primary key(PK)
did – Foreign key(FK)

PK constraint – must have value and must be unique
FK constraint – if null no constraint, else if value then it must comply with referential integrity.

PK,FK –‘did INTEGER’ - thus only 1 employee can manage a department. But an employee can manage more then one departments. Department field must be present.
FK – ‘ssn CHAR(11)’ – this field can be null (a foreign key can be null). Thus a department can be managed by nobody.
FK – ‘ssn CHAR(11) NOT NULL’ – Each department must have a manager.

I think question 1.4.1 is misleading. Will query it.

oh nice.... okay, I will try to recall my assignment...

No need to recall your assignment - Assignment 1, question 1.4.1 will not count any marks.

vbiljja

What other questions in assignment 1 won't count for marks?

vbiljja

I'm new to this chat room, are you a lecturer or did the lecturer inform you that "Assignment 1, question 1.4.1 will not count any marks." if so what about question 1.4.2 becuase these questions are both linked

vbiljja is the lecturer.

"Assignment 1, question 1.4.1" is not phrased correctly, but you will be able to answer question 1.4.2

The answer to your question about what assignment questions to do and errata lies here:
http://osprey.unisa.ac.za/mod.htm?qcode=INF418-P

And no, I am no the lecturer.