Click to See Complete Forum and Search --> : in what table should we name it in ms access?


powerup
11-16-2005, 10:11 PM
OrderNo Customer OrderNo ItemNo Item Qty Price
245 1 PN768 1 $35
245 2 PN656 3 $15
245 SteelCo 246 1 PN371 1 $2.99
246 Acme Corp 246 2 PN015 7 $5
after entering this in datasheet which name table we should save us?

buntine
11-16-2005, 11:13 PM
I would recommend you call the table "Invoice".

Regards.

buntine
11-16-2005, 11:14 PM
Also, you should add a field named InvoiceID and set it as the Primary Key.

powerup
11-18-2005, 10:24 PM
Owner of a small video store needs a database to keep track over 1,000 to 2,000 video tapes. the specification are given as follows:
Each videotapes has a tape number. for each movie, we need to know its title and category(e.g. comedy,suspense,drama.action,war,or sci-fi).they do have multiple copies of many movies. each movie is given specific id, and then track which movie a tape contains. a tape may be either Beta or VHS format.
They have at least one tape for each movie we track and each tape is always a copy of a single, specific movie. tapes are very long and they don’t have any movies, which require multiple tapes.
The customer asks for movies starring specific actors. so star actors appearing in each movie should be recorded. Not all movies have star actors. Customers like to know each actor’s”real”birth name and date of birth. they only keep track actors who appear in the movies of their inventory.
They have lots of customers. they only rent videos to people who have joined” video club.” to belong to club, they must have good credit. For each club member, they like to keep their first and last name, current phone number, and current address. And ,of course each club member has a membership number.
Then we need to keep track of what videotapes each customer currently has checked out. A customer may check out multiple videos tapes at any given time.
We just track current rentals. we do not keep track of any rental histories.

Firstly in this assignment I have to write an introduction please mr/mrs if you could help me in this.
How can I write the introduction?
Also please I would like to know is are names of salesman and member ship club unique or just null?
If we set the attributes of club member how can we know null and not null the same for sales man the person who’s rent and sells the cassette films to his customer.?
Thank you
i promise super moderater this will be last question no more after this :D

buntine
11-19-2005, 03:06 AM
Is this homework? I will not do your homework for you.