Sounds good. I'm out all day today, but will be avaliable this evening and tomorrow.
For this, I'll need to know what base information you want to use and I'll need the forms that you have for the diagrams and the business rule specification sheet.
If you can, please provide me some general information about your group so I can make it come from that perspective.
Ok. thank you I will provide the information:
the three business rules for Fernando's shop. (I personally don't understand those at all =)Afterwards, if you have time, you and I can redo the diagrams to incorporate the business rules.
Mr. Riley,
I hope this will help also: this is what I gathered from the group
we are to take all of the PK's and tell how they relate to the other tables as a Foreign Key. So in reality, we are only working with the PK's..
And here the other portion of this: this is the objective below
Submit a Word document listing what you agree with and what you do not agree with in your team's decisions. Give your reasons for your individual decisions and why you agree or disagree with your team.
this is all the information that I have gathered.. this will be scheduled on Friday..
XXXXXXX,
There's several things I need here as follows:
Is there any other information or are there any other examples that you can provide me so I can get a better idea of what is needed?
This is one of the group work..
Preliminary Field List
List of Subject
Skateboard Model
Customers
Description
Products
Wheel Type
Suppliers
Bearing Type
Orders
Product Number
Accessories
Quantity
Event
Price
Supplier Name
Supplier Contact
Customer Name
Address
City
State
Zip
Phone
Fax
Email
Purchase
Item Total
Discount
Tax
Grand Total
Employee
Event Location
Event Description
Event Date
Customer Table
Name
*******
Product Table
Events Table
Location
Date
Supplier Table
********
Contact
Skateboard Models
I have added data to the preliminary field list such as "employee" this will allow us to keep track of who sold the merchandise. This is helpful in such cases of customer returns or issues that may come about in the near future and will allow us to reference back to that employee. Another field that I added was "purchase" this will itemize the purchases made by the customer. I also added to the preliminary field list "tax" this will allow us to ring up the customer at the computer straight from the database add tax automatically. This will eliminate the separate cash register process. This will also help to look up customer purchase history. I went through the subject list and crossed off all the subjects that have been utilized in the final field list. I have decided that the "orders" field is typically the same as the "purchase" field that I have added so I have deleted it. I also deleted the "accessories" since "product number and description" will identify both skateboards and accessories.
The basic table relationships will start with the suppliers table of which has a relationship with the product table. This will contain the supplier's information which will be linked to the product table which will contain all the model information. This will then lead us to the purchase that the customer has made which will then cause a relationship with the product table. Another scenario could also be if a customer ordered a product then a relationship with the product table and the customer table is created. If the customer chooses to be on the mailing list then a relationship with the events table and the customer table is created.
Final Table List
Type
Data
This is the name or type of skateboard given by the supplier
This is a brief description of the skateboards function and appearance
This is a brief description of the type of wheel that the product has and its function
This is a brief description of the type of bearing that the product has and its function
This is a serial number given to the product from the supplier to identify one from another
This is the amount either purchase from the customer or the amount on hand at the store depending on the table
This is the amount that the product is from the supplier or our cost
This is the name of the company that is one of our suppliers
This is the name of the representative that we deal with from each supplier we use
This is our customers name who has either purchased or ordered a product
This is the customers for the mailing list or suppliers street address depending on what table it is being used in
This the city of which either the customer lives or where the supplier is in
This is the state of which either the customer lives or where the supplier is in
This is the zip of which either the customer or the supplier
This is the phone number for either the customer or the supplier
This is the fax number for either the customer or the supplier
This is the email for either the customer or the supplier contact
This is the purchase or the order information for the customer
This is the item total for the customers order or purchase
This is for any discounts given from the store to the customer or the supplier
This is the tax which is calculated by the location of which the store is located in
This is the grand total for the customers purchase or order including any discounts and the tax
This is the employee that has processed the order or has completed the purchase
This is the location for any skateboarding event that has been scheduled
This is the description of the skateboarding event that has been scheduled
This is the date of the skateboarding event that has been scheduled
This is the final field list that I have come up with. This has the descriptions of every field I have chosen for the tables. This will allow Fernando's sister to easily ring up a customer along with storing data for the store and the customers.
Here is the other person:
Table Relationships
Here are the tables and Primary Keys that I was working with:
Customers CustomerID
Products ProductID
Supplier SupplierID
Orders OrderID
Events EventID
Employees EmployeeID
**I really don't see the need for an accessories table, because aren't accessories also products? Couldn't a company just list them all together since some manufactures make both the main product and the accessory?
Now we have to show sample tables and how they relate to each other
CustomerCustomerID Name ProductID OrderID EmployeeID1 John Bond 35 S456 2 Carlita Culebra 25 S457 11000
ProductsProductID Product SupplierID Price25 AbcKnees AbcBoards $29.9935 BigDaddyStreet AbcBoards $299.9945 FlipandTrick TrickBoards $279.99
SuppliersSupplierID Contact ProductID PriceAbcBoards Alice Beard 25 $29.99AbcBoards Alice Beard 35 $299.99TrickBoards Amy Poole 45 $279.99
OrdersOrderID CustomerID ProductID EmployeeIDS456 1 35S457 2 25 11000
EventsEventID Name CustomerID ParticipateE100 NYFallRally 1 yesE100 NYFallRally 2 no
EmployeesEmployeeID Name Address City State 11000 Carlita Culebra 500 N Jackson Denton ME11001 Suzy Jones XXX XXXX XXX Denton ME
Mr. Riley, Do you think you can do something about it. pls.
Ok, so here's what I think we need to do. Please confirm before I put it all together:1. final table list (Names of the tables ONLY) and PKs for those tables.2. Define relationships between the tables.3. Create a diagram for each relationship.4. Determine at least 3 Business rules and update the diagrams with the constraints.5. Complete a Business Rule Specification Sheet for for at least 1 Business rule.6. Generate text defining business rules and rationale for each. (I'm guessing this will come from the specification sheet listed in #5.)
Is this correct?
Am I missing anything?
Do you have a sample of what the diagram should look like? I can make it up, but I'm not sure what you're needing, exactly.
Do you have a copy of the Business Rule Specification Sheet?
Please try what you think is best.. because I am clueless right now
This is what the group did in excel.. you think you can come up with something..
Are you there, I was waiting for the work.
Honestly, I don't know. This isn't a technical term so, based on your direction to do the best I can, I'm guessing a Business Rule will be something like a guideline that a company has that drives how you relate data in a table. I saw a reference to a Business Rule Specification Sheet and asked for a copy as I figured this would give me a better idea of what you needed, but it sounds like you don't have this either.
I really want to help you and give you a good quality product, you're used to that from me, but I don't feel like I have a super firm grasp on what is really needed here and I'd hate to give you something that isn't quite right. Based on your directions, I'm planning on doing my best, but I'm having to do some guessing as to what the professor really wants as there are things being asked for, using terms, that don't show up in the real world...only in college.
Let me know if I'm going the wrong direction here so I don't waste time setting up something that won't work in the end.
I believe that you are in the right track..I know that you will do your best.
I think I've got it done. Go to https://67.148.16.35/3rdrock.zip. (Note that you'll get an error about a SSL Certificate and you'll need to accept that.) Please review it and let me know what you think. I should be avaliable for the next 1-2 hours.
Sr. Network Engineer
A+, MCP, MCSE, 15 years of experience