SQL Oracle Database design

Although my first degrees are in chemistry I’ve been getting heavily into computing for a few years now, so I took advantage of working at a university to do a part time degree in computing science. It’s pretty good actually as the university pays. I am only allowed to take one unit per semester usually on a Tuesday and Wednesday evening. It’s a bit intense at times juggling a full time job and a degree but I enjoy it. This semester there wasn’t an evening unit available so I enrolled on a daytime unit ‘Database Principles and Applications’. Each unit normally has two assignments and an exam, the first assignment wasn’t too bad, I had to take a description of a bookshop, translate it into an ER diagram then generate a series of relations from the diagram. But, the second assignment was a killer for me, I really though it was going to be the first assignment I wasn’t able to hand in. The task was to decompose a relation in 1NF into a set of relations in 3NF then design some queeries. In the end I think I was reading more complexity into the task than was actually there so I really struggled. Once I’d got over the first part it all seemed a bit clearer. Unfortunataly the deadline was 17:00 on Fri 19th and things only started clarity only occured around 15:00 so I was franticaly trying to get the SQL statements to work and write a report for the dealine. In the end I didn’t quite finish but I managed most of it and hopefully have done enough to pass. In hindsight I should have started earlier but, I’ve always been like that, never starting things early enough and just making the deadline, suppose it’s too late to change at the age of 45. Ho Hum!