By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,341 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Database Question

P: 34
Hi can someone help me with a scenario i am having trouble with, i have made the database, but its not complete i was just wondering whether some one could help m

Thanks
Mar 11 '07 #1
Share this Question
Share on Google+
8 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi can someone help me with a scenario i am having trouble with, i have made the database, but its not complete i was just wondering whether some one could help m

Thanks
Describe your problem and we'll see if we can help.

Mary
Mar 11 '07 #2

P: 34
Hi i have made the database so far but i need help with the Reservations table and also some forms and querys.
Mar 11 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi i have made the database so far but i need help with the Reservations table and also some forms and querys.
If you want help you will have to explain in detail what is wrong. Lets just start with the table. Can you post the metadata of the table and tell us what is wrong.

Here is an example of how to post table MetaData :
Table Name=tblBookings
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; Autonumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Mary
Mar 11 '07 #4

P: 34
Hi Mary,

This is my ERD

Member 1:N Copy N : Video 1: N Reservations N : 1 Member
Mar 11 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Mary,

This is my ERD

Member 1:N Copy N : Video 1: N Reservations N : 1 Member
What's the relationship between Copy and Video?

Please follow the format I gave you as it gives me a better image of the structure.

Mary
Mar 11 '07 #6

P: 34
Hi Mary the relationship between Copy and Video is Many Copies to One Video

Thanks
Mar 11 '07 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Mary the relationship between Copy and Video is Many Copies to One Video

Thanks
I still need them in the format I asked for and I also need you to tell me what the problem is.

Mary
Mar 11 '07 #8

NeoPa
Expert Mod 15k+
P: 31,494
Hi Mary the relationship between Copy and Video is Many Copies to One Video

Thanks
ThinBoy, You need to provide the information requested otherwise how can you expect a sensible answer?
This question is akin to asking :
"I have a problem. What's the solution?"
If you can't see why that would be a difficult question to answer then you need to stop and think for a bit.
Mar 12 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.