October 15, 2011 at 5:15 pm
Sandra’s Ski Hire rents out skiing equipment. Equipment is divided
into two general categories - clothing (boots, jackets, gloves etc.) and
hardware (skis etc.) Each piece of equipment has an identification
code, (equip-ID,) that uniquely identifies it, as well as an
equipment type code, (type-code). So, for example, a particular snow
board may have an equip-ID of 1027, and a type-code of SB. Each
equipment item of the same type has the same daily and weekly hire rate
and deposit. That is, for all snowboards, the daily rate is $30, the
weekly rate is $100 and the deposit is $100.
Sandra has many customers. She needs to keep records of their cust-ID,
name and address so that she can send out advertising brochures to them
each year as winter approaches and so that she can chase them if they do
not return hired equipment. She also keeps information on how much each
customer has spent in the last year.
These customers visit the shop in order to hire equipment. For example
a customer may come in wanting to hire 2 sets of skis, 2 sets of poles,
a snow board, 3 set of boots and 3 jackets; all this would count as one
hire represented by a unique hire-no. For each hire, Sandra needs to
record for each individual piece of equipment its equip-ID, the
expected-return-date and actual-return-date.
Pieces of equipment need repairs - Sandra does none of these, but sends
them all to various businesses around town. She needs to keep track on
the cost of repairs on each item, as well as the repairer-no, name and
address of each repairer.
Sandra needs to produce several reports including an inventory report,
showing for every piece of equipment, the equip-ID, type-code, size, and
color, date of purchase, original cost, manufacturer’s name and the
total number of times hired.
Note: not all equipment may be returned on the same date for the one
hire.
Notes Following this to be answered... Please
How Do I Indicate primary keys by means of underlining.
Any new attribute to act as a primary key if you give an
alternate key from the given attributes.
Whay could be the alternate key and foreign keys
how can I get the third normal form.
October 15, 2011 at 5:34 pm
pintoam (10/15/2011)
Sandra’s Ski Hire rents out skiing equipment..
.
.
Please email the answer to pintoam@hotmail.com....
You're going to get more out of your homework assignment if you put some of your own effort into it. Plus generally, no one is going to spoon feed you the answers and send it to you by email. If you have specific questions, participate here in the forum and people will be glad to help.
October 16, 2011 at 4:02 am
rgtft (10/15/2011)
pintoam (10/15/2011)
Sandra’s Ski Hire rents out skiing equipment..
.
.
Please email the answer to pintoam@hotmail.com....
You're going to get more out of your homework assignment if you put some of your own effort into it. Plus generally, no one is going to spoon feed you the answers and send it to you by email. If you have specific questions, participate here in the forum and people will be glad to help.
:hehe:
October 16, 2011 at 7:04 am
If the Equipment hired is damaged at the customer place before returning . What do I need to do How do I keep record of that. Where do I keep that customer deposit in which table....$100 as deposit...
you come to me and ask me 2 sets of skis, 2 sets of poles, a snow board, 3 set of boots and 3 jackets, Where this information goes which table...
October 16, 2011 at 7:17 am
Relational theory is all about de-duplicating data for accuracy and rapid querying. If you are struggling then you are missing out on what this question is trying to teach you and I suggest you review your notes and look at some simpler excercises. Better still ask your teacher if you have one.
pintoam (10/16/2011)
If the Equipment hired is damaged at the customer place before returning . What do I need to do How do I keep record of that. Where do I keep that customer deposit in which table....$100 as deposit...
I suggest this is somesort of transaction table with a transaction type column and linked to your customer record? You understand what a primary key and foreign key is right?
you come to me and ask me 2 sets of skis, 2 sets of poles, a snow board, 3 set of boots and 3 jackets, Where this information goes which table...
Probably a table linked to you product list and transaction table which inturn would decrement your inventory.
October 16, 2011 at 10:55 pm
as i m seeing, its a pretty straight forward simple design, you can have tables like Equipments,Customers,HireEquipements, DamagedEquipments etc etc. and you have to set some business rules,
i will suggest you to go through some examples on BOL and come up with a rough design and post it, we will ready to discuss on that.
October 16, 2011 at 11:40 pm
ghanshyam.kundu (10/16/2011)
as i m seeing, its a pretty straight forward simple design, you can have tables like Equipments,Customers,HireEquipements, DamagedEquipments etc etc. and you have to set some business rules,i will suggest you to go through some examples on BOL and come up with a rough design and post it, we will ready to discuss on that.
Yes, I do agree with you. Or you can hire services of some professional as well.
October 17, 2011 at 1:18 am
It would be good for you (in long run) to read and understand the DB Design concepts before throwing your issues (Professional / Academic) on forums.
First normal form (1NF)
Table faithfully represents a relation and has no repeating groups
Second normal form (2NF)
No non-prime attribute in the table is functionally dependent on a proper subset of a candidate key
Third normal form (3NF)
Every non-prime attribute is non-transitively dependent on every candidate key in the table
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply