Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Requirements:

Make a database from scratch which contains, at a minimum, the elements listed below. The kind of database you make is up to you. Though, it is highly encourage you to build a "real-world" application where you make a database for work, school, or your own use using real data. For illustration, you might use sales, wage, inventory or other data from work, incorporate a project from another class, or build an application to use for school.

A brief paragraph or two describeing the aim of your database and its functionality, plus a detailed E-R diagram.

It must include, at a minimum,

Tables:

• At least three related tables.
• Use accurate relationships.
• Enforce referential integrity.
• Make all foreign keys look-up fields.
• Use cascade update.

Queries (these queries can be linked to forms and/or reports):

• Multiple table and parameter.
• Make find outd field.
• Crosstabs, find duplicates, find unmatched, and find top value queries (select two).
• Append, delete, make-table, and update queries (select two).

Forms:

• Main and sub form.
• Hyperlink.
• Data entry controls; textboxes, list boxes, combo boxes, option groups, check boxes, toggle buttons, and command buttons (select four)
• Format forms attractively using color, shading, lines and fonts.

Reports:

• Export reports to Word or Excel.
• Apply sorting and grouping options.
• Make a summary find outd field.
• Apply conditional formatting.
• Make a custom format and use for all reports.
• Format forms attractively using color, shading, lines and fonts.

Macros:

• Make and run a macro.
• Make and use a switchboard.

Customization:

• Make a custom menu, toolbar, or short-cut menu and attach it to the switchboard.
• Set start-up options.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

1 how are qbe tools and sql similar2 how are they

1. How are QBE tools and SQL similar? 2. How are they different? 3. What is a data warehouse? 4. How does it differ from a database?

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

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

Data analysis projectyou have contracted with a local

Data Analysis Project You have contracted with a local school district to help them decide whether to use an interactive computer program or a standard chapter from a textbook to teach students to use fractions. The scho ...

Oracle databaseusing the schema you developed in homework 1

Oracle Database Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns an ...

Restaurants and fast-food chains rely heavily on business

Restaurants and fast-food chains rely heavily on business intelligence to make important decisions. Casinos do as well. Some of the leading restaurants, fast-food chains, and casinos using data warehouses include AFC Ent ...

Query 1list all movies played in landmark or music box

Query 1 List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates. Query 2 List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, la ...

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Problem iyoull be happy to know that we made a strong case

Problem I "You'll be happy to know that we made a strong case to manage¬ment that we should hire a new systems analyst to specialize in ecommerce development," says Al Falfa, a systems analyst for the multi-outlet intern ...

  • 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