N00b To ER Modelling, Please Help!

Dec 8, 2005

Okay, can anyone help me with the following:-

I have to create a database on theatre booking system. So far, ive identified the following entities:

Customer(Customer ID, Title, Initials, Surname) Customer ID is PK
Bookings(-------)
Play(Playname, Playwright, Number Of Characters, Length(min)) Playname is PK
Actors(-------)

i do not know what to create as attributes for the bookings table, especially seeing as the attributes have to relate to customer and play. for the actors table i was thinking of putting in the following attributes:-

Actor ID, Name, Age, Playname, Role (Actor ID is PK)

but i was unsure if they worked, although i think they would, because playname from the play table would be a foreign key in the actors table. this is where i come into conflict with the bookings table, ie what could add to teh custoemr table as a primary key that would make a suitable foreign key in the bookings table, and what could be a suitable primary key in teh bookings table, and also a suitable foreign key in the play table? please help, its an urgent issue. thanks very much for your time.

Fergal

View Replies


ADVERTISEMENT

Database Modelling!

Oct 6, 2005

I wondered if you might be able to help me with a database problem I have. I'm doing this in access so I've attached a copy of the relationships window.

This database is suppose to store stock levels and orders for a chain of stores that all stock the same products. So I've got a product table, a company table with all the different stores and a linking table called stock.

So far i think my design works fine for this. My problem is that some products can come in various colours and others dont. With the current design you'd have enter different colours as unique products in the product table when in fact their only different attribute is colour. This seems a bit redundant and I feel i should have another table with colours in it linking to the product id in the product table.

My problem then is I not sure how to link the product table to the stock table when there is no option of colour and a colour table to the stock table when their is multiple colours.

Basically I need to be able to query the db to show stock levels for individual colours alongside products that dont have various colours. However, I also need to be able query for overall stock of a particular product (ignoring colours) alogin side products without any colours.

Cheers for any help you can offer!

Luke

View 2 Replies View Related

Relational Modelling Confusion !!??

Mar 9, 2005

Im trying to figure out how to model 'Printer' and 'Cartridge' information. The relationship between them is Many to Many, but to add to my confusion, more than one cartridge can be used in a printer (Black + different colour cartridges). Adding a new entity to resolve the Many to Many does not solve this issue of how a printer can have, for example, a black cartridge and 3 different coloured cartridges.

Any ideas how to model this please?? I have been toiling with it for some time and I keep going round in circles :confused:

I'm sure it shouldn't be as difficult as it seems, so I'm hopeful someone might be able to set me straight :o

View 1 Replies View Related

My God I'm Such A N00b

Sep 13, 2006

In Access 2000 I need to create a primary key out of elements from two different tables across several different fields. So the first question is how do I do this? The second question is where do I do this, i.e. is there a wizard of sorts that can walk me through this? I thought I'd checked everywhere and I just can't seem to find anything. If someone could let me know I'd appreciate it so much.

View 5 Replies View Related

N00b...query Parameters

Oct 1, 2006

Hey guys, I have a simple design question I hope someone can help me with. I have little to no experience with Access, but I know enough to get around. Anyways, I'm working as an extern for a rock band. One of my assignments is to create a publicity contact database. I have all my forms and tables set up but I'm having some trouble creating my query. There are about 10 fields in the contact table. I want the user to be able to search any one of those 10 fields OR any combination of them. Is there a way to do this with only one query, where it willl prompt the user for only the fields they have selected to search?

View 2 Replies View Related

N00b Question. Button Won't UNPRESS?

Aug 31, 2006

Hello.

So, basically I have an input form. I disabled pretty much all of the controls and instead of using the left and right arrow buttons I wanted to create my own ones to go to the next record. What happens is that the button pushes down, but doesn't unpush. And then if i push it again it pops back up.

This is what is in it, as far as code goes for my button:
DoCmd.GoToRecord , , acNewRec

... so, yah. It seems kind of idiotic, but i hope someone can tell me what's up because it's really annoying!

Thanks!

View 2 Replies View Related

N00b Question. Query Criteria.

Sep 1, 2006

Okay. So, this is my set up.

I have a form that has various input fields that are connected to my main table. What I want to do is have my form allow the user to enter information, leaving some of it blank if they don't want it, and then press a button and it will open the query with the arguements given. The problem i'm having is... when i leave a field blank, it doesn't pull up anything, but if i fill everything out then it's fine. Right now my criteria on my query sections just link directly to the combo boxes that i have created on the input forms. I believe i just have to have additional criteria, telling it to ignore null or something like that... but i'm not sure how! Please aide?

thanks!

View 1 Replies View Related

N00b Question. Input Forms...

Aug 31, 2006

Hello,

When I open an already created form just linked to a table to input new information. At the bottom is says, for example, 1 of 30. How can I make it so that it just adds a new entry at the end of that 30, being 31? And then, perhaps sorting the table... after all the data has been entered. Your help would be much appreciated!!

Thanks!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved