Directions :

You must decide on a fictional business to run. The business must be one that uses a database with at least 3 types of data: customer relations data, financial management data, and product/service related data.

YOUR TASK : Develop a Database and a PowerPoint presentation for your business.

Guidelines

During Week 2 :

Post your ideas explaining what your fictional business will be, what it will do, and how your database will support it. Give the name of the business and tell what its mission is. Does it sell a product or provide a service? You can make all this information up but be realistic. Tell what data/information your database will manage in order to support the business.

As you are working on your Semester Project if you feel you need to make some changes in your plan you must reflect the changes in your post. (When you complete your class project your posting(s) must agree with what you ended up doing). That means you need to monitor your posting(s) on the Discussion Board.

During week 2 – week 5 :

While developing your database keep in mind your business must contain the three types of data as described above. Check the first part of Module 2 “Guidelines for Designing Databases” in order to create your tables. (Your tables and their relationships are the foundation of your database. Follow the guidelines but be sure to use your own data.) When you finish the database you must also have the following:
At least 15 database objects total (with at least 5 being tables)
You can enter data into your tables by typing it in, however, you must import data from another source for at least 1 table. You must be able to explain in your PowerPoint how this imported data will be used in your business Save your import steps so that your import shows up as a saved import in the database. (see pp. 80-86, 95-97)
At least 3 of your tables must be related. Referential Integrity must always be enforced. (see pp. 97-103)
Tables must contain at least 200 records collectively (not individually).
You must have at least 1 multitable query (see pp. 129-130). You must also have an exact match query (see p. 142-144), a query using a comparison operator (see p. 147-149), a query using multiple selection criteria (see pp. 149-153), and a query with an aggregate function (see p. 161-165).
You must have at least 1 form that is an input form for 1 of your tables.
You must have at least 1 form that is designed using a theme, picture(s), and text color (see pp. 185-192). You must also have a form containing a main form and a subform (see pp. 200-204).
You must have at least 1 report with grouped data (see p. 209), with correct alignment of field values (ss p.213-214), font color and a picture (ss pp.217-218), and conditional formatting (see pp. 218- 220)
You must export at least one object as an HTML document. You must be able to explain in your PowerPoint how this HTML document will be used in your business. Save your export steps so that your export shows up as a saved export in the database.
All database objects and relationships must contribute to the functionality of the database’s purpose and what it is doing. (In other words you can’t just randomly add tables, forms and reports for no particular reason.)
NOTE : You must be able to explain the purpose of each object in your PowerPoint presentation.

When you finish your Database :

Submit database to Canvas (in Modules, Week 5)
Post a PowerPoint presentation on the Discussion Board in the appropriate folder. Make sure your first slide is an Introductory slide with your name, your businesses’ name, and the Date. This PowerPoint must explain your business, how your database objects support it, and how your imported/exported data relates to your business. Presentation should be from 5 – 7 slides (including your introductory slide).

To Download Click Here > ITSW1307 CLASS PROJECT Online-9.pdf