Create a database from scratch

Assignment Help Database Management System
Reference no: EM131929

Requirements

Create a database from scratch that contains, at a minimum, the elements listed below. The type of database you create is up to you. However, I highly encourage you to build a "real-world" application where you create a database for work, school, or your own use using real data. For example, 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 describing the purpose of your database an its functionality, plus a detailed E-R diagram.

It should include, at a minimum,

Tables

  • At least three related tables
  • Use correct 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
  • Create calculated field
  • Crosstabs, find duplicates, find unmatched, and find top value queries (choose two)
  • Append, delete, make-table, and update queries (choose two)


Forms

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


Reports

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


Macros

  • Create and run a macro
  • Create and use a switchboard


Customization

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

 

Grades will be determined by the completed objectives listed below.

Area

Skill

Points (0-5)

Tables

At least three related tables

 

Relationships

Correct and appropriate relationships

 

 

All foreign keys look-up fields

 

Queries

Multiple table and parameter

 

 

Calculated field

 

 

Crosstabs, find duplicates, find unmatched, and find top value queries (choose two)

 

 

Append, delete, make-table, and update queries (choose two)

 

Forms

Main and subform

 

 

Data entry controls; textboxes, list boxes, combo boxes, option groups, check boxes, toggle buttons, and command buttons (choose four)

 

 

Format forms attractively using color, shading, lines, and fonts, add hyperlink

 

Reports

Export reports to Word or Excel

 

 

Calculated summary fields

 

 

Apply sorting and grouping options

 

 

Format forms attractively using color, shading, lines, and fonts

 

 

Create a custom format and use for all reports

 

Macros or Modules

Create and use switchboards

 

 

Use VBA to customize a database by creating functions, event procedures, etc.

 

 

Usability

Is the application intuitive and easy to use?  Are objects well placed?

 

Functionality

Does the application do what it is supposed to do?  Does it function correctly and efficiently?

 

Aesthetics

Does the application look inviting?  Are things spelled correctly?

 

Total

 

 

 

 

Reference no: EM131929

Previous Q& A

  Display contrasting approaches

This assessment task needs that groups examine two firms from the one industry that display contrasting (e.g. insurgent/defensive) approaches.

  Dihybrid two plants is done and seed pod shape is examined

A dihybrid cross of two plants is done and the seed pod shape is examined

  Data collection plan for a particular purpose

Data Collection Plan for a particular purpose for an organization

  Design a wireframe prototype

Design a wireframe prototype to meet the needs of the personas and requirements.

  Case study - choose a public inquiry

Effective time management forms part of the assessment criteria

  Prepare a web application

Prepare a web application that will be used to keep track of patients registering in a hospital.

  Demonstrate the influence of environmental and behavioural

Demonstrate the influence of environmental and behavioural factors on structure, corporate size and strategy

  What is bill''s opportunity cost of producing one hat

What is Bill's opportunity cost of producing one hat, In which of the two activities does Mary have a comparative advantage.

  Write a program that will be used to gather statistical data

Write a program that will be used to gather statistical data about the number of movies

  Create a viral marketing video of antique products

Create a viral marketing video of antique products

Reviews

Write a Review

 

Similar Q& A

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Database system development

The database application project (DAP) for this course consists of the creation of a fully functional Microsoft Access database application for a real client.

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Baxter aviation database

ER diagram for the Baxter Aviation database

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Creating database structure using sql

creating database structure using SQL

  Relational algebra operations

List the sequence of relational algebra operations needed to implement the queries.

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