Design a relational database of your choice

Assignment Help Computer Engineering

Reference no: EM1335895

Create a relational database of your choice (HR database, Retail outlet database, Address book database are examples). The database should contain no more than 6 tables. Define 3 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?

Reference no: EM1335895

Questions Cloud

Explain factors to consider when making pricing decisions : Explain Factors to consider when making pricing decisions and what factors should you consider in making this pricing decision

Project staffing skills for successful it project managers : What types of project staffing skills have been identified as important for successful IT project managers?

Government regulation and self regulation : Can businesses properly self-regulate in lieu of governmental regulation?

Explain the goals of the change initiative : Prepare a memo to the department heads of Pegasus to explain the goals of the change initiative, which is the reorganization. In this memo you must gain the trust of the department heads by a clear explanation for the need for change.

Design a relational database of your choice : make a relational database of your choice (HR database, Retail outlet database, Address book database are examples). The database should contain no more than 6 tables.

Explain why will this specialization increase production : Why will resources specialize according to their comparative advantages. Explain why will this specialization increase production.

Find at least five eeo regulations : Find at least five EEO regulations with which your organization must comply and describe how your HR department manages compliance with these regulations.

Advertising strategy : MATS has a new client from Chile who owns a vineyard. He is looking to MATS to help him create online advertisements that promote his company and product coupons.

How to use access to create db and tables : design a database for a human resources group. List a few different tables and colums to store the HR information. State assumptions in creating the DB and underlying database objects. Use Access to create DB and tables.

User Account

All Pages