Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started