December 1st, 2012, 12:12 PM
Homework Help Access Tables
I'm working on one of my homework problems but am very stuck just getting only the correct tables. I could skip it but really want to learn how it would work. First I wrote down everything in lists in an Excel spreadsheet then started putting it in Access as I put it all in, It doesn't look like it will work, thus I'm stuck. Maybe you guys can help me out and see what I'm doing wrong. I uploaded the Excel spreadsheet with the tables/entities. URL: Tabels.xlsx
The HW Problem:
December 4th, 2012, 07:11 AM
Why do you not think it will work? Overall it looks like you have a decent start. I do have some suggestions looking at your propsed tables. One, do not duplicate data. If you have a member's name in the tblMember, then don't repeat it in tblDVDRented. Same thing with the DVD title.
You want to try and store the smallest possible peices of data in field. example. Instead of storing a full name in a field (tblEmployee). First name, middle initial, Last name, and Suffix might all be seperate fields. It makes sorting and minipulation of the name much easier. For example listing the full names makes alphabetical order very difficult. If you list the last names first, then printing out a name as first and last becomes very difficult. These should always be seperate fields. Same thing with Addresses (tblMember). Street, City, State, Zip, Apt# should always be seperate fields. Having one Address feild makes it very difficult to sort or filter records by area.
Post back with the specific concerns you have as to why you don't think these tables will work.