Tags: studies
Bored out of my mind doing the homework: the ERD
Hmmm. Or more like drained.
I was in the office from 230pm to 1030pm. I met up with my groupmates so we could draw the ERD and write down the entities and attributes we need for the data dictionary.
I know, I know, we seem kinda slow in figuring things out. I suppose the heat didn't help at all.
But personally, I know I am a bit pathetic when it comes to ERMs.
Anyhow, do you guys know a tool I could use to draw them? Thanks!
PS: This homework is for the training I am participating in. And to think we have individual case studies to write! O_o;
I was in the office from 230pm to 1030pm. I met up with my groupmates so we could draw the ERD and write down the entities and attributes we need for the data dictionary.
I know, I know, we seem kinda slow in figuring things out. I suppose the heat didn't help at all.
But personally, I know I am a bit pathetic when it comes to ERMs.
Anyhow, do you guys know a tool I could use to draw them? Thanks!
PS: This homework is for the training I am participating in. And to think we have individual case studies to write! O_o;
PHP and MySQL learning today
Thea was the one who helped me today. Hmmmm. Looks like I would read up on the SELECT statement because it seems to be one of the useful stuff. I have been playing around with the links database and I need to make sure that they could be arranged accordingly.
The logic, it seems to me, is that I think of physical objects. Like different fruits in different baskets on the table. I need to know WHERE (which basket) certain fruits are and if I will arrange them ORDER of their names alphabetically or what.
Saw this somewhere:
Keyword Description
SELECT Retrieves fields from one or more tables.
FROM Tables containing the fields.
WHERE Criteria to restrict the records returned.
GROUP BY Determines how the records should be grouped.
HAVING Used with GROUP BY to specify the criteria for the grouped records.
ORDER BY Criteria for ordering the records.
LIMIT Limit the number of records returned.
The logic, it seems to me, is that I think of physical objects. Like different fruits in different baskets on the table. I need to know WHERE (which basket) certain fruits are and if I will arrange them ORDER of their names alphabetically or what.
Saw this somewhere:
Keyword Description
SELECT Retrieves fields from one or more tables.
FROM Tables containing the fields.
WHERE Criteria to restrict the records returned.
GROUP BY Determines how the records should be grouped.
HAVING Used with GROUP BY to specify the criteria for the grouped records.
ORDER BY Criteria for ordering the records.
LIMIT Limit the number of records returned.