Inventory tracking database

Assignment Help Data Structure & Algorithms

Reference no: EM1380292

Question: Construct a relational database of your choice (HR database, Retail outlet database, Address book database are examples). The DB should contain no more than six tables. Define three business requirements that this database will provide (hint: you may think of the business requirements as 3 questions that the database must be able to provide answers to). Based on these business requirements, outline all the steps for creating the tables and retrieving data from the tables. (Show the basic syntax of CREATE and SELECT as well). Show a sample result set from the database also.

For example, the inventory tracking database that we have used as an example may have the following functionality:

1. Who is the Vendor for Part #123?
2. What is the quantity of Part #123 on hand at present?
3. What is the unit price of Part #123?

Submit a word doc answering all parts of the question. ACCESS is not required.

Reference no: EM1380292

Questions Cloud

Creating an idef1x diagram : Construct an IDEF1X diagram that demonstrate only entities and relationships. Name each relationship and specify its cardinalities.

Detailed strategies to recruit : What are the qualifications of a trained Mechanical Engineer and what selection methods are best to assess whether or not an applicant meets or exceeds those qualifications

Create an idef1x entity relationships diagram : The Metropolitan Housing Agency is a non profit corporation that advocates the development and improvement of low income housing.

Separate inventory database : A 20-year old corporation, SewWorld, comprised of 6-locations in three states, sells sewing machines, sewing related software, and accessories. Each store sells between 3-5 different brands of sewing equipments.

Inventory tracking database : Construct a relational database of your choice. The DB should contain no more than six tables. Define three business requirements that this database will provide.

How does dividend payment affect stock price : What are advantages and disadvantages of stock repurchases relative to traditional dividend payments and how does dividend payment affect stock price? any supporting evidence?

Creating database for a human resources group : Construct a database for a human resources group. List a few different tables and columns to store the HR information.

Question related to normalization : Think about a typical job order that might include the following information. Design a single table to hold all the data needed to store a job order including this information.

User Account

All Pages