- 2 You Have Been Asked To Build A Database For A Small Company They Sell Used Furniture They Want You To Keep Track Of 1 (167.3 KiB) Viewed 43 times
- 2 You Have Been Asked To Build A Database For A Small Company They Sell Used Furniture They Want You To Keep Track Of 2 (144.69 KiB) Viewed 43 times
2. You have been asked to build a database for a small company. They sell used furniture. They want you to keep track of their products, their shop locations and employee information. a) List all the column names. Make sure they are descriptive. b) For each of the 3 tables (items in bold, above), clearly identify the columns that belong to each table. c) List your choice of the primary key (PK) column or columns in each table. d) Identify any composite keys that you can think of. It's best to create tables in your word processing application such as Word and list the columns for each table. For example: PRODUCT productId (PK) Etc. 3. Your textbook shows another way to represent a elation/table. For example, Student (StudentID, StudentNumber, FirstName, LastName, StreetAddress, City, CellPhone) in section 3.2 of your book. Show the tables identified for question 3 using this linear format.
4. As a student, you take courses. These courses have books and instructors. a) List all the column names. Make sure they are descriptive. b) For each of the 3 tables (items in bold, above), clearly identify the columns that belong to each table. c) List your choice of the primary key (PK) column or columns in each table. d) Identify the foreign key (FK) columns as you create relationships between these tables. When you state your FK columns, make sure to identify the table the column(s) refer to. e) Associating actual data with tables help in understanding the underlying relationships between your tables. Provide some sample data for each of the tables. At least 3 rows of data in each table. For example, for a table that holds data for NFL coaches, we may have the following data: id 100 200 300 teamName Broncos Patriots Raiders CoachName Vic Fangio Bill Belichick Jon Gruden