Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Database System Development v.1

The database application project (or DAP) for this course comprises of the creation of a fully functional Microsoft Access database application for a real client. It is recommended to select a potential client organization with which you have some familiarity, ex: a bowling league, a small business or a club. The application must not be complex. The final Access database application prototype should meet the given minimum criteria:

Tables:

1) A minimum of 5 tables, comprising intersection tables where necessary;

2) Tables should have adequate data (minimum of 8 records each) to fully describe the functionalities of your database application;

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

Queries:

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

2) Of such five, at least one query should prompt the user for input (that is, parameter query) and use the input in the criteria for the query;

3) Of such five, at least one query should use an aggregate function to compute a summary statistic for a suitable field in a table.

4) Of such five, at least two queries should retrieve data from multiple tables.

Forms:

1 All the required forms for inputting and displaying the data in your database as needed 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 such four, at least two reports must be based on a multiple-table query.

3) At least one report must display grouped data.

User Interface:

1) Give a user interface to access the features or characteristics of the prototype.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9638

Have any Question? 


Related Questions in DBMS

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

Create a data definition class to model one product sold at

Create a data definition class to model one product sold at a bakery. The product will have a description, cost, and quantity in stock. Instance methods include: accessors for each instance variable, non-validating mutat ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

Lab modifying a database design in visiothis assignment

Lab: Modifying a Database Design in Visio This assignment contains two Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use "Appendix A: De ...

Virtualization fundamentalsunit 3 research projectwrite an

Virtualization Fundamentals Unit 3 Research Project Write an overview of *any two* of the following topics. Each overview should be between one half and one full page long. You should use a minimum of two sources for eac ...

Individual outsourcing risksprepare a 8- to 10-slide

Individual: Outsourcing Risks Prepare a 8- to 10-slide PowerPoint presentation, including speaker notes, that identifies the possible risks to an organization in each of the following outsourcing situations: • The use of ...

Homeworkgiven the relations below answer the following

HOMEWORK Given the relations below, answer the following queries using SQL. Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. MEMB ERS ME ...

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen