RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 137,851
Posts: 5,328,189
Members: 24,552
Currently online: 670
Newest member: SpammetySpam

TrekToday headlines

Cubify Star Trek 3DMe Mini Figurines
By: T'Bonz on Jul 11

Latest Official Starships Collection Ships
By: T'Bonz on Jul 10

Seven of Nine Bobble Head
By: T'Bonz on Jul 9

Pegg The Prankster
By: T'Bonz on Jul 9

More Trek Stars Join Unbelievable!!!!!
By: T'Bonz on Jul 8

Star Trek #35 Preview
By: T'Bonz on Jul 8

New ThinkGeek Trek Apparel
By: T'Bonz on Jul 7

Star Trek Movie Prop Auction
By: T'Bonz on Jul 7

Drexler: NX Engineering Room Construction
By: T'Bonz on Jul 7

New Trek Home Fashions
By: T'Bonz on Jul 4


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
Respect the Beef
 
Robert Maxwell's Avatar
 
Location: Right behind you!
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.
__________________
"Holy shit! It's Beef Supreme!"
The Journeyman - Buy it now! Maybe?
My world simulation project!
My blog
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:16 PM.

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