Note: you may not use any business/organizations and functions based on customers/orders/order details, nor business/organizations and functions based on courses/students/departments, nor business/organizations and functions based on hospitals/patients; these are business/organizations and functions used in copious sample exercises by the textbook.

For the business or organization you have chosen to develop a database management system (application), refine or improve the following deliverables you produced for Assignments 1, 2,3 and 4:

1. name of the business or organization;
2. product, product line, or service;
3. some major corporate functions;
4. some business processes;
5. any existing computer applications;
6. some major data entity types ("high level groupings");
7. some needs or problems that are to be addressed by developing a new database application;
8. some ways employees and managers will use the potential new database application;
   

9. some strategic planning factors: long term vision, some major planning goals, some critical success factors, and some problem areas;
10. some corporate planning objects: organizational units, locations, some major corporate functions, and some major data entity types ("high level data groupings");
11. an organization chart along functional decomposition lines;
12. a preliminary data model -- a high level entity-relationship diagram;
13. a formal statement of proposal for a new database application to solve a problem, meet a need, or take advantage of an opportunity -- and thus serve the strategic plan of the business or organization;
14. a planning matrix showing function-to-data entity usage expected in the proposed new system;
15. (optional) other planning matrices as the group sees necessary or helpful in planning: location-to-function, unit-to-function, unit-to-data entity, location-to-data entity.
    

16. complete a detailed e-r diagram for the new database application system; include details such as all entities, all attributes (especially identifiers/keys), relationships, and upper/lower cardinalities for those entities you will develop and use;
17. define at least five business rules that will impact the database; at least 2 structural and at least 2 operational; describe them clearly and in detail; specify the data entities, attributes, or relationships to which they are connected;
18. depict the rules on an e-r diagram using the Ross symbol conventions.
    

19. define in detail all business processes required to successfully support at least two business functions; only the two functions on which the group is working; use a stepwise, sequential structure: "a happens and then b happens and then c happens";
20. define in detail some specific "views" of data entities and attributes needed by different persons working in the business functional areas you are supporting (i.e, to perform the processes you defined above);
21. define in detail at least 3 different forms/screens/displays, complete with details for each section or block; in an accompanying narrative, tell who will use them, how they will be used and to support what processes;
22. define in detail at least 3 reports, complete with details for each section of block on each page; in an accompanying narrative, tell who will use them, how they will be used and to support what processes.
    

23. Construct a logical schema for the relations in your dbis, using either the graphic convention used in your textbook or the one we used in class. Provisos: include at least 3 different relations, with all their attributes and all keys; include the referential integrity "blue lines" from foreign keys to primary keys; be sure to correctly transform your eer diagram into relations, as directed by the textbook's mapping "Steps 1 through 7." (Chapter 6)
24. Using Access, build a phsyical design for the data components of your dbis: relations/tables, fields, keys, all field properties needed to enforce business rules via data integrity, relationships between tables, and enforcement of relational integrity. Provisos: at least 3 tables, linked by the relation/linking steps shown in class (i.e., 2 relationships); use all data types shown in class, even if you need to add new attributes/fields to enable you to do so; implement your business rules that relate to data integrity, by using all properties demonstrated in class, as appropriate for each field and data type.
25. Using Access, build a physical design for the application components of your dbis: forms, reports, views/queries. Provisos: at least 3 forms, 2 of which are multi-table; at least 3 reports, 2 of which are multi-table; at least 3 views/queries, 2 of which are multi-table; implement business rules where possible; make sure that everything works correctly.
26. Briefly describe how each form, report, and view/query will be used by the end-users of the business, and what improvements will be realized in business functional areas as a result of such use.
    

    Note: make certain that no data specified on a view, form, or report are not included in the data model specified.

Then produce the following new deliverables for this Assignment 5/Project:

1. Make sure you have popluated your data tables with representative data; at least 10 records for each table; and be sure to have more than one record on the "many" sides of all "one-to-many" relationships. Turn in on a diskette.
2. Write SQL DDL code for your tables, attributes, and keys. Use the Notepad in Windows. Turn in on a diskette.
3. Using the directions provided and the exercise we did in class, upload your mdb file and a least 2 data access pages (for 2 different funtions of your business) to the assigned webserver.
4. Complete the "client-server" exercise for your mdb -- using the instructions provided and following the technique we used in class. Make sure you include all the data access pages you made, when you turn in your diskette.
5. Write an "excutive summary" explaining and describing your implementation decisions the way we did in class, but applying the strategies to your dbis and business.

Textbook Aids. See McFadden, Hoffer, Prescott (MHP) -- references to the Pine Valley Furniture business "case":
• Chapter 8.
• Chapter 9.
• Access book of your choice.

Insert your completed, printed deliverables into your portfolio, in the fifth section of your dividers. Save your Access ".mdb" file and your SQL coding to an otherwise empty diskette and insert the diskette into the side sleve of the cover of your portfolio; be sure it is secured. Make sure your portfolio is properly identifed with your names. Turn in your portfolio at or before the due date/time.

Overview & Objectives | Full Syllabus & Grading | Calendar

Text & Other Resources | Assignments | Tests & Exams

Warren E. Duclos, Jr. | A.B. Freeman School of Business | Tulane University

Inquire about the course --

duclos@tulane.edu
Tel (ofc): (504) 865-5555

Fax: (504) 865-5562

Unless otherwise noted, all material is:
Copyright © 1997, 1998, 1999, 2000, 2001 The A. B. Freeman School of Business at Tulane University.
All rights reserved.