Axia College Material Appendix

Axia College Material Appendix B IT/260 Database Design Document Gift Shop Inventory Date Modified: 7-28-2010 Week:5 Part 1: Introduction (due Week Two) a) Application Summary I selected the Gift Shop Inventory application. b) Database Software I will use SQL 2008 Express Edition. This software closely resembles the software I use at work. I am familiar with the flexibility of this software. I am very comfortable in using SQL 2008. SQL is also one of the industry standard RDMS. c) Database Design Elements Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is gathered, I will divide this information into tables. Information will be properly placed into columns and I will set a primary key. Upon completion of table design, I will set the relationships between tables. I will refine my design and apply normalization rules to my design. Part 2: Database Design (due Week Three) Entities and Attributes Entities for this database application will include a Customer, Products, Orders, Sales Rep and Shipping table.Part 3: Relationships, Components, and Features (due Week Four) Define what an ERD is and why it is important as a tool in the database design process. The ERD represents conceptualization by end users of what the database has to offer. As a database designer, it is important for you to use the ERD tool so the components, attributes, entities and relationships are clearly visible. The ERD tool will held database designers make sure they are capturing all required data and that all tables needed are built around that data. b) Entity Relationship Diagram c) Components and Features [Identify the components and features that are going to be used in your database application. Part 4: Queries and Forms (due Week Five) a) Queries Customer info- Select * from Customers-This query will give information on how many customers are shopping at the Gift Shop. Orders Table- Select * from Orders this will give a listing of all orders. Should a specific date range be needed. We could Select * from Orders Where OrderDate between ‘2010-01-01’ and ‘2010-01-31’. This will give us all orders for the month of January 2010. We track inventory by querying the Product Table. Select Prod, Num, ProdDesc, Quantity on Hand from Products. We could see who sales associates are in the Gift shop by querying the Sales Rep table. b) Forms Explain your vision for what forms and menus should appear in their database application.  Part 5: Testing and Implementation Plan (due Week Seven) a) Testing Plan Provide a set of steps that you will take to test thoroughly your database application. Include scenarios that will be tested, and activities that will be performed to validate that your database application works correctly. b) Implementation Plan Provide a list of steps that you will take for the implementation phase of this project. Part 6: File Maintenance and Storage Plan (due Week Eight) a) File Maintenance and Storage Plan

Cite this page