relational database
Not what you're looking for?
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?
Submit a word doc answering all parts of the question. ACCESS is not required.
Purchase this Solution
Solution Summary
Create a relational database of your choice
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic Networking Questions
This quiz consists of some basic networking questions.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
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.
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.