Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Accounting questions

Question

Show that the difference quotient for f(x) = cos x is given by

Answered: 1 week ago

Question

Find the exact value of each expression. cos5/12

Answered: 1 week ago