Creating a database using ms access

Assignment Help Basic Computer Science
Reference no: EM131032473

You will be creating a database using MS Access that could be used to organize something. But first, you will use SimNet to refresh your memory about MS Access.

The minimum elements it should contain follow:

  • Create at least 3 tables, 2 primary tables and a related table

oConsider using a concatenated key for the primary key in the related table

  • Impose appropriate field types and lengths on all fields
  • Ensure the database is in 2NF (second normal form)
  • Insert the 3 data integrity (data validation) checks / controls listed below:

oRequire that a field that is not a primary key be populated (Access automatically requires primary keys be populated.)

oImpose limits on the value that can be entered into a number or currency field

oEstablish a list of valid values that can be used in a field

  • Force referential integrity between your tables
  • Add 1 index on a field other than a primary key (Again, Access automatically indexes primary keys.)
  • Create 2 queries that include this functionality, work and make sense:

oData from multiple tables

oAn aggregate total in the datasheet view

oA sort

oComplex selection criteria (uses And or Or logic)

  • Create 1 report
  • Create 1 form with a subform

In addition to uploading the database, you should upload a Word file where you:

1. Describe your database and what is being tracked in it.

2. Note which are primary and which are related tables.

3. 4. Note the field you indexed and describe the reason for indexing the field you chose.

6. List the fields that are primary and foreign keys in each table.

7. Explain the type of relationship (one-to-one, one-to-many, many-to-many) that exists between your tables.

It should go without saying, but this database needs to be original - one you created on your own, for this class, at this time, and for this assignment. You cannot use the database model created during the Database Down & Dirty day. Submitting a database created by someone else, or for another class, will not be accepted

Reference no: EM131032473

Questions Cloud

Explain what made you want to research that topic : LING 102: Spring 2016 - Research Paper Presentation - You will need to consider the sequence of the information you will share to make sure it will occur in a logical fashion. Also consider transition use.
Prepare a comprehensive report directed to an australian asx : prepare a comprehensive report directed to an Australian ASX Top 100 listed corporation detailing a critical analysis of the effectiveness of the corporation to meet the obligations of the conceptual framework of accounting
Did the school follow the correct disciplinary procedures : Did the school follow the correct disciplinary procedures? Discuss why or why not. Would you have done anything differently, according to IDEA's procedures?
What is the final velocity of the masses : A mass of .6 kg moving with a velocity of 2.4 m/s in the positive direction experiences a totally inelastic collision with a mass of 1.1 kg. What is the final velocity of the masses?
Creating a database using ms access : Creating a database using MS Access that could be used to organize something. But first, you will use SimNet to refresh your memory about MS Access.
How do elements of mise-en-scene constitute their ways : How do the elements of "Mise-en-Scene" and "patterns of repetition" function and constitute their ways through the entire film, "White Light/Black Rain"?
Image for further instructions on cloud computing : Image for further instructions on Cloud Computing
Information about the performance of students : You are interested in obtaining information about the performance of students in your statistics class and seeing how this performance is affected by several factors such as sex.
Age of the mother-marital status of mother : Problem: As part of a data base on new births at a hospital some variables recorded are the age of the mother, marital status of the mother (single, married, divorced, other), weight of the baby, and sex of the baby. Of these variables

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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