MySQL Forums
Forum List  »  Newbie

Re: Can I create this type of database with MySQL?
Posted by: Barry Galbraith
Date: March 17, 2015 03:26PM

Quote

1. Name & address of company approached.
2. Contact details: Name of manager, email and telephone number.
3. Date I applied for job.
4. Other information: which allows me to records if I get a reply email or letter etc.
You could do that with MySQL, but it would be better suited to a spreadsheet because there is only one of everything for each row.

Now, if you were submitting several job applications to the one company, or to several people within that company, or to an agency which was recruiting for several companies, then you would need a Relational Database (MySQL) for that.

Imagine an Address/Phone book.
You could have several people at the one address (a family). In that family, each might have a mobile number, and a home phone number, and an email address (or two!) or some other contact info.
So you would need a people list, an address list (referenced by people list), a phone list, and people to phone brige table for many-to-many relation (many people share home phone, but have individual mobile), and so on.

Where everything is one-to-one, like your task, use a spreadsheet.
Where there are one-to-many and / or many-to-many use a database.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can I create this type of database with MySQL?
March 17, 2015 03:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.