ACCESS ASSIGNMENT 1 1. OBJECTIVE The primary objective of this assignment is to teach you how to create tables in Microsoft Access. However, by completing this assignment, you will also be able to gain DBMS skills such as (1) backing up an Access file, (2) setting up table structures and field properties, and (3) establishing table relationships, and you will gain familiarity with DBMS concepts such as (1) primary and foreign keys. (2) one-to-many and many-to- many relationships, (3) a relationship table (i.e., a bridge entity), (4) referential integrity, and (5) a REAL diagram. II. COMPANY BACKGROUND Almost a year ago Tom Waren, owner of Waren Distributing was approached about an idea for a new business venture by his twin sister Jill. Jill had been considering starting a VIDEO SHOPPING NETWORK show to distribute various products to retail customers. Jill wanted Tom to sell his products to her new business Waren Unlimited at cost and in exchange Tom would receive a 20% share of Waren Unlimited profits after one year. Jill started operations in July without Tom's participation, but he decided to join with Jill in September. Several cable television stations have broadcast the program, which demonstrates name brand products and flashes a 1-800 number that viewers can dial to order items. Waren Unlimited's product pricing is very competitive as inventories are purchased in very large quantities directly from Waren Distributing and a number of other manufacturers/distributors. Also, overhead is minimal in comparison to retail outlets. This is a critical time in Waren Unlimited's growth. National cable network time has recently been purchased and decisions need to be made on how to best use the expensive national air-time. You have been asked to develop some relational database tables Waren Unlimited can use to collect data on operating activities. The data will be used to formulate future business plans. TIL PARTIAL REAL DIAGRAM Below you will find selected entities and relationship for Waren Unlimited. A complete database would consist of customer payment records, inventory purchases, etc. and would involve complete interactions between all aspects of the database. However, these few tables shown below will provide a representative exposure to relational databases and provide you with the understanding of how to create and use tables. ACCESS ASSIGNMENT 1 1. OBJECTIVE The primary objective of this assignment is to teach you how to create tables in Microsoft Access. However, by completing this assignment, you will also be able to gain DBMS skills such as (1) backing up an Access file, (2) setting up table structures and field properties, and (3) establishing table relationships, and you will gain familiarity with DBMS concepts such as (1) primary and foreign keys. (2) one-to-many and many-to- many relationships, (3) a relationship table (i.e., a bridge entity), (4) referential integrity, and (5) a REAL diagram. II. COMPANY BACKGROUND Almost a year ago Tom Waren, owner of Waren Distributing was approached about an idea for a new business venture by his twin sister Jill. Jill had been considering starting a VIDEO SHOPPING NETWORK show to distribute various products to retail customers. Jill wanted Tom to sell his products to her new business Waren Unlimited at cost and in exchange Tom would receive a 20% share of Waren Unlimited profits after one year. Jill started operations in July without Tom's participation, but he decided to join with Jill in September. Several cable television stations have broadcast the program, which demonstrates name brand products and flashes a 1-800 number that viewers can dial to order items. Waren Unlimited's product pricing is very competitive as inventories are purchased in very large quantities directly from Waren Distributing and a number of other manufacturers/distributors. Also, overhead is minimal in comparison to retail outlets. This is a critical time in Waren Unlimited's growth. National cable network time has recently been purchased and decisions need to be made on how to best use the expensive national air-time. You have been asked to develop some relational database tables Waren Unlimited can use to collect data on operating activities. The data will be used to formulate future business plans. TIL PARTIAL REAL DIAGRAM Below you will find selected entities and relationship for Waren Unlimited. A complete database would consist of customer payment records, inventory purchases, etc. and would involve complete interactions between all aspects of the database. However, these few tables shown below will provide a representative exposure to relational databases and provide you with the understanding of how to create and use tables
