One of the dealership's legacy stand-alone systems in the preceding exercise is the salesperson work schedule system. This system was developed in the 1980 s on a single \(P C\), using BASE III, to keep track of each salesperson's daily and weekly work schedule The dealership plans to retire this antiquated system and incorporate it into is relational database system. What are two or three tables you might expect to find in a scheduling system? Using Figure 14.5 as an example. show these tables in a simple, physical database schema. Include the primary key, any foreign keys, one or two nonkey attributes, and a few values for each object.

Figure 14.5:-

Transcribed Image Text:

Custours Toddle Customer Number to imary kay 10712 10133 Cuesease Nam Su Human primary key sign 21101 Lidered Producis Fable Chdar Number Perde Number (forsign key) Furia ex Quality Dedard 305 77012 2001 M34 73X13 100 AD34 Alz3 71812 R 97133 77313 15 Customer Walan 1458-77 0:00 Frudnets Table Fondust Faber Trudner Desetipation Quantly 77312 Widget BULAY BAMIX Widg 6 17H15 Widgm 52 77301 Gudget TIP Quig