Create a relational database of your choice (HR database, Retail outlet database, Address book database are examples).
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.
- Plain text response
- Attached file(s):
- DBMS.zip
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- What is relational database? What does it contain? What is the purpose of primary key in a database? - What is relational database? What does it contain? What is the purpose of primary key in a database?
- DBMS - How many types of DBMS in computer industry since IBM started its first commercial computer equipment?
- Flat-file database - What are some of the key differences between a flat file and a relational database? Which of the two storage methods do you think is most useful in a real-world application?
- Database Concept - What are the main differences between the relational model and the hierarchical model?
- If the problem is simple one should use a sequential or relational file and if the problem is complex one should choose to use a database? - Suppose you wanted to keep a record of everything you own in your house. You could use a sequential data file to keep track of common items such as ‘cloths’. The sequential file may contain multiple ...
