Mr. Smith wants to computerize his gadget store which does Sales & Service of mobile devices at Rowan campus. (Glassboro & Camden New Jersey). Lets help design a database. Task:

Design your Table, Columns, Keys in an Excel file. There is no limitation on how many tables you can design. Suggested : at least 6 tables.

attached here is an example of how the database should look like with some entities

Search in Sheet Home | Layout Tables Charts SmartArt | Formulas Data Review Edit Alignment abc Font Fill : Calibri (Body) -11 Wrap Text, General Clear B 11U Insert Delete FormatThemes Aa Formatting J24 Primary Key NOT NULL NULL NOT NULL NOT NULL NOT NULL NOT NULL Locationl EmployeelD LocationID INT VARCHAR 100 VARCHARI100 VARCHARIs0) VARCHARI50) VARCHAR(10) VARCHAR(12) VARCHARISO) VARCHAR(100) VARCHARI100 NOT NULL VARCHAR[100 NOT NULL VARCHAR100 NULL VARCHAR[12) NULL Boolean 8 10 ZIP NOT NULL 12 13 14 15 16 17 18 19 20 21 Description: This table is used to capture physical address of the store. Description: This table is used to store all the employees who work in the store. It also identifies who is the Owner of the store, so they can be contacted if needed 23 24 25 26 27 28 29 31 32 34 36 37 38 39 41 42 43 Sheeti HE Normal view Sum-0