Purchase Solution

Populate Tables

Not what you're looking for?

Ask Custom Question

Create and populate tables within a database using MS Access that supports the following business rules:

Employees all have employee ID's, first names, last names, middle initials, street addresses, city, state, postal codes, and a date of birth.

Departments all have department IDs, department names, and a department description, and a department manager..

An employee can work for only one department.
Each department can have multiple employees but only one manager.
Create 5 fictional employees within the employee table.
Create 2 fictional departments within the department table of the database.
Products each have a product ID, product name, product description, weight, and vendorID.
Vendors each have a Vendor ID, Vendor name, address, city, state, and postal code.
Products can be ordered from multiple vendors and Vendors can ship multiple products. (hint: you need to resolve this many to many relationship somehow)
Create at least 4 fictional products
Create at least 3 fictional vendors.

Purchase this Solution

Solution Summary

Create and populate tables within a database using MS Access that supports the following business rules.

Purchase this Solution


Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Networking Questions

This quiz consists of some basic networking questions.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.