Question: Follow your database design to create the remaining tables in the Antiques database using any method you choose. Be certain to specify the field

Follow your database design to create the remaining tables in the Antiques 

Follow your database design to create the remaining tables in the Antiques database using any method you choose. Be certain to specify the field names, data types, field descriptions, and field sizes as you create each table. Create validation rules and vali- dation text, input masks, field captions, default values, and lookup fields as necessary to ensure that users enter consistent, complete, and accurate data in the tables. From the discovery phase, Tim and Linda gathered the following information that you need to consider in your table designs: Tax ID numbers for dealers are unique. The valid booth locations at the mall are Inside Perimeter, Outside Perimeter, and Aisle. (On Linda's map-see Figure 1.37 in Chapter 1-booths that line the outside edge of the mall are outside perimeter booths, booths across from outside perimeter booths are inside perimeter booths, and booths on the inside rows are aisle booths.) Valid booth sizes are 8 x 8, 8 x 10, 8 x 12,8 x 16, 8 x 20, 12 x 8, 12 x 10, 12 x 12, and 12 x 18.

Step by Step Solution

3.47 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Section 1 Database Design Hershey College is a small liberal arts college in Hershey Pennsylvania Because studentenrollment at Hershey College is small the college participates competitively only in f... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!