Database application development, Database Management System

Assignment Help:

The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you select a potential client organization with which you have some familiarity, e.g. a bowling league, a small business, or a club. The application should not be complex. The final Access database application prototype must meet the following minimum criteria:

Tables: 

1.  A minimum of 5 tables, including intersection tables where necessary;

2.  Tables must have enough data (minimum of 8 records each) to fully demonstrate the functionalities of your database application (You may need to add some records to the baseline template);

3.  At least four table relationships, all of which must have referential integrity enforced.

 Queries:

1.  At least five queries (total) appropriate to the database requirements;

2.  Of these five, at least one query must prompt the user for input (i.e., parameter query) and use the input in the criteria for the query;

3.  Of these five, at least one query must use an aggregate function to calculate a summary statistic for an appropriate field in a table.

4.  Of these five, at least one query must retrieve data from multiple tables.

Forms:

1.  All the necessary forms for inputting and displaying the data in your database as required by your client. One form per table for data entry

2.  At least one form displaying data from a minimum of two tables. Reports:

1.  At least four reports (total) for data output;

2.  Of these four, at least two reports should be based on a multiple-table query.

3.  At least one report should display grouped data.

Menu:

1.  Provide a user interface to access the features of the prototype. See User Interface handouts.

Milestone 1: Write a memo to me describing your client, an initial analysis of the organization's problem, and what business process will be automated.

Milestone 2:

List of Interview questions

Milestone 3

Interview client

Milestone 4:

Draft of Requirements Analysis section

Milestone 5: 

Draft of Database Design section

Milestone 6:

Prototype Testing

Milestone 7

Draft of Implementation, Conclusions, and Lessons Learned sections

Milestone 8:  

Final Database Application Project Report and Database


Related Discussions:- Database application development

What is the disadvantage of a call by reference, What is the disadvantage o...

What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

What are the four main characteristics of the database, What are the four m...

What are the four main characteristics of the database approach? The four major characteristics of the database approach are: 1. Self-describing nature of a database system. 2.

Select statement-data manipulation language, SELECT Statement This stat...

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

Describe the storage structure of indexed sequential files, Describe the st...

Describe the storage structure of indexed sequential files and their access method.  Ans:   Storage structure of Indexed Sequential files and their access: To achieve fast rand

Explain composite attribute in sql, Explain Composite attribute in SQL ? ...

Explain Composite attribute in SQL ? Composite attribute: A composite attribute has many components, each of that is atomic or composite.

Abstract data structures, The C_Artist  application will be developed using...

The C_Artist  application will be developed using the C language (C99 standards) and will be able to compile without warnings and link and run in the Swinburne computer laboratorie

Hangman, a method named WonGame that checks each letter in the word is matc...

a method named WonGame that checks each letter in the word is matched by its label

Relational algebra, Relational Algebra is a set of basic operations used to...

Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

The average amount of their orders , Make SQL statements for the following ...

Make SQL statements for the following scenarios. Your response should contain SQL statement, output and any other assumptions you have made to arrive at the answer. For Colorado cu

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd