Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

You are required to develop a working database solution in Microsoft Access 2010 that will maintain customer, employee, product, and transaction details for an existing company of you’re choosing. Tables must be normalized so that your database shows referential integrity, does not have redundant data, and updates, deletions, and insertions are done properly. Your database should contain tables, relationships, forms, queries, reports and sample data.

The solution should demonstrate the following:

Tables and Relationships: Multiple tables for customer, employee, product, and transaction details as well as relationships with referential integrity should be created. Fields should be of an appropriated at a type and use valid action rules and input masks where necessary such as with customer age and phone numbers respectively.

Forms: Appropriate forms for entering and amending records should be created where required. At least one form should enable users to enter data into two tables simultaneously.

Queries: A minimum of two queries demonstrating an ability to ask detailed problems of your database should be created where appropriate to display relevant information e.g. all transactions that have taken place within the last week.

Reports: A minimum of two reports should be created to display relevant information from tables and queries.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Organizations want information organizations need

Organizations want information. Organizations need information. However, information must be in an organized format that supports the creation of business intelligence. Otherwise, according to Rebecca Wettemann, vice pre ...

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 ...

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

At this point you decide to implement a hash structure for

At this point, you decide to implement a Hash structure for the contributor data to prepare for searches. You will read the contributor information from a file provided; it is a comma delimited (CSV) file. As each record ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start­up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Discussionyou have been asked to help a critical

Discussion You have been asked to help a critical infrastructure company in analyzing the privacy and security of a SCADA system. Conduct research on the topic and answer the following: 1. How would you describe general ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

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 ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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