Follow your database design to create the remaining tables in the Antiques database using any method...

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

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 the full answer