could someone help me
- Thread starter tawhid111
- Start date
Technically speaking your assignment does not say that you have to create forms, but you still need to populate the rentals table with some records (20 if I remember correctly) and that would be a lot easier with the forms.
But before we get to that, what happened to the media type table I suggested and is part of your assignment (media category)?
I thought that table was in one of your earlier versions?
But before we get to that, what happened to the media type table I suggested and is part of your assignment (media category)?
I thought that table was in one of your earlier versions?
yeah i need 4 tables i added mediaID under media ? im not sure i have to submit this by midnight .
Code:
Your task is to create a simple relational database from the field list above. The required tables are Customers, Media, Categories, and Rentals, each of which should be properly provided with a primary key, and each of which should be related to other tables as required.
The following is a list of essential data items to be recorded. As noted above, there may be a few additional fields required as keys for the tables you will create from these fields.
[LIST]
[*]date of rental
[*]due date
[*]media item title
[*]media item category
[*]category description
[*]category code
[*]customer ID#
[*]customer lastname
[*]customer firstname
[*]customer address
[*]customer phone#
[/LIST]
All four database tables should be populated with records as follows:
[LIST]
[*]Customers - at least 10
[*]Categories - three records, one describing each of the the media types: DVD, VHS or Game
[*]Media - at least 30 records, representing a selection of DVD movies, VHS movies and Games.
[*]Rentals - at least 20 records.
[/LIST]Added the media tables
No, the various types should be RECORDS in the table not FIELDS
The table should be structured as follows:
tblMediaTypes
-pkMediaTypeID primary key, autonumber
-txtMediaType text field
The data in the table should look like this:
pkMediaTypeID|txtMediaType
1|DVD
2|Blue Ray DVD
3|Game
4|VHS
The table should be structured as follows:
tblMediaTypes
-pkMediaTypeID primary key, autonumber
-txtMediaType text field
The data in the table should look like this:
pkMediaTypeID|txtMediaType
1|DVD
2|Blue Ray DVD
3|Game
4|VHS
i dont understand it could you just edit it would really apreciate it
No, this is a basic table that you should know how to handle for your assignment. If I do it for you, you will not learn. Create the table as I show with the 2 fields. You can then add the 4 records to the table. You canadd the records directly to the table or you can add them using a form (your choice).
have a look at this one
Last edited:
The next step is to link the media type table back to the media table. In your media table that means removing the text Blu Ray, Game etc. and replacing it with the corresponding key value from the media type table. Since changing the value from the text to the corresponding number, is beyond the scope of your assignment, I went ahead and did that with an Update query in the attached database. Now, you need to create a relationship between the media table and the media type table using the mediatypeID fields in both tables. One media type can apply to many media items in the media table (one-to-many relationship). You can use the same approach for the genre field in your media table (create a table that holds each unique genre type, and then replace the genre name in the media table with the corresponding key value from the genre table and make the join), but that was not part of your assignment from what I can tell.
Once you have the relationship established, you can go back to the form or to add the records in the rental table directly.
Once you have the relationship established, you can go back to the form or to add the records in the rental table directly.
You cannot join an autonumber field to a text field. The DB I posted in post 32 is correct.
Just like you did in the media and customer tables. The rental table just needs to have numerical values for all the key fields (customerID, DVDID) rather that the text. For example (using the DB I posted in post 32), if customer Sean Paul (customerID =3) rents Star Trek (DVDID=12), you would enter those numbers (3,12) in the rental table in their respective fields. You would then need to supply the date values to finish the record. This is where the forms would be easier. Perhaps the tutorials on this site might help.
Just like you did in the media and customer tables. The rental table just needs to have numerical values for all the key fields (customerID, DVDID) rather that the text. For example (using the DB I posted in post 32), if customer Sean Paul (customerID =3) rents Star Trek (DVDID=12), you would enter those numbers (3,12) in the rental table in their respective fields. You would then need to supply the date values to finish the record. This is where the forms would be easier. Perhaps the tutorials on this site might help.
is it suppose to be like this ? and on the forms isn't it for looking up the records ? if so how do it do it since if i type customer id it does not let do anything
Last edited:
have a look at #35
ok i see how to flip through the records at the bottom there's a record bar ... is there anything else that's needs to be done ?
the form actually looks nice now i can see the records how did u do that ?? as for the records is it ok now ? did i even do it correctly ? please suggest if there anything missing
