RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 139,550
Posts: 5,422,172
Members: 24,805
Currently online: 461
Newest member: Dylancute

TrekToday headlines

Retro Review: Tears of the Prophets
By: Michelle on Sep 12

New Wizkids Attack Wing Ships
By: T'Bonz on Sep 12

Coto Drama Sold To Fox
By: T'Bonz on Sep 12

Braga Inks Deal
By: T'Bonz on Sep 12

Remastered Original Series Re-release
By: T'Bonz on Sep 11

UK Trek Ships Calendar Debuts
By: T'Bonz on Sep 10

Quinto In The Slap
By: T'Bonz on Sep 9

Burton On Shatner’s Brown Bag Wine Tasting
By: T'Bonz on Sep 9

New Trek Trading Card Series
By: T'Bonz on Sep 8

New Red Shirt Diaries Episode
By: T'Bonz on Sep 8


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Lounges & General Chat > Miscellaneous

Miscellaneous Discussion of non-Trek topics.

Reply
 
Thread Tools
Old May 5 2012, 04:13 PM   #1
The Fatman
Captain
 
The Fatman's Avatar
 
Location: Buffalo, NY
Send a message via AIM to The Fatman
Anyone know Databases and willing to help me with some homework?

I am doing a homework project for an Access Databases class, and need to design a database in 3rd normal form for a fictional computer repair company. She says it just needs to be very basic, only 6-10 tables. The problem I am running into is connecting my tblInvoice with my tblParts.

tblInvoice has InvoiceID (primary key), Date, Paid(Y/N), Balance, CustID (foreign key - tblCustomer) and PartID (foreign key - tblParts)

Long story short, how do I account for the posibility of multiple part ID's on the invoice (if necessary)? Do I need to put multiple partID fields on tblInvoice? I emailed the teacher for help, and she told me I wasn't normalized enough and to think of it like a "class registration system"... which didn't help me any. I'd appreciate any thoughts anyone could offer me
The Fatman is offline   Reply With Quote
Old May 5 2012, 04:30 PM   #2
Robert Maxwell
Not Your Toy
 
Robert Maxwell's Avatar
 
Location: A broken roof
View Robert Maxwell's Twitter Profile Send a message via ICQ to Robert Maxwell Send a message via AIM to Robert Maxwell Send a message via Windows Live Messenger to Robert Maxwell Send a message via Yahoo to Robert Maxwell
Re: Anyone know Databases and willing to help me with some homework?

Create another table called tblInvoiceParts. It will have two columns:

Invoice - Reference to an InvoiceID in tblInvoice.
Part - Reference to a PartID in tblParts.

Don't have PartID in tblInvoice--save it for tblInvoiceParts.

Generally speaking, if you have a field that may need multiple values, you should set it up as a child table with one of the columns pointing back to the parent table, and the other column holding the actual data you want (be it an ID for another table, or a data value like a phone number.)

Database normalization is one of my specialties. I hope that helps! Let me know if you need further guidance.
__________________
It's all false love and affection
I has a blag.
Robert Maxwell is offline   Reply With Quote
Old May 5 2012, 05:24 PM   #3
The Fatman
Captain
 
The Fatman's Avatar
 
Location: Buffalo, NY
Send a message via AIM to The Fatman
Re: Anyone know Databases and willing to help me with some homework?

Simple as that... Thanks, Robert Maxwell!
The Fatman is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.