Computer Science Homework Solutions
Problem
#100933

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 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

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 Summary

This solution offers a view of possibilities for tables to be listed in a database design. Also shown is a demonstration of expanding these fields, determining other necessary data, and eliminating duplicated information (redundancy).

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
$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
  • 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 ...
  • 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 ...
  • CMOS - Why do you think the trend is to store configuration information on a motherboard in CMOS setup rather than by using jumpers or switches?
  • 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 ...
Browse