Computer Science Homework Solutions
Problem
#106228

Establishing table structure

You are now going to create the final table list for Fernando's Skate Shop. Use the following preliminary field list and list of subjects to get started. Realize that the lists are incomplete and you may need to add more information as necessary by inferring data from what you know about the case. Be sure to provide a rationale as to why you add information. Be as detailed as possible in explaining your choices, and describe the steps you take to complete the list.

Preliminary Field List                              List of Subjects          mission objectives
Skateboard model                                  Customers
Description                                              Products
Accessories                                            Suppliers
Wheel Type                                              Orders
Bearing Type                                         Accessories
Product Number                                         Event
Quantity  
Price  
Supplier Name  
Supplier Contact  
Customer Name  
Address  
City  
State  
Zip  
Phone  
Fax  
Email  
Item Total  
Discount  
Grand Total  
Event Location  
Event Description  
Event Date  

Prepare your final table list and your rationale

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$15.96)
Included in Download
  • Plain text response
  • Attached file(s):
    • 106228_skateShop.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Create the final table list - You are now going to create the final table list for Fernando's Skate Shop. Use the following preliminary field list and list of subjects to get started. Realize that the lists are incomplete and you ...
  • Implement key types and maintain referential integrity of the database. - Using the final table list you created for Learning Event 3, select the Primary Keys for each table in your list. Then, select one of your tables and complete field specifications for each field. Use ...
  • Database Concepts - Huffman Trucking - Using MS Access, create the preliminary (no keys and no relationships) database tables for the Driver Log ERD in Huffman Trucking on the Virtual Organization portal, which is attached . Please cr ...
  • Windows XP Creation Files - I open my computer and create a new folders named Apex Carton, Manufacturing, Material Suppliers, East Coast and West Coast. Then move the East Coast and West Coast folders into the Material Suppliers ...
  • Information Systems Multiple Choice Review Questions - See attached file for full problem description.
Browse