Reference no: EM131097210
Information Integration
In this homework you are going to design and implement a simple database application.
This phase is to be implemented by each student individually, without the help of others. You will design and implement an inventory database as follows:
Generic instructions: Your database should have at least 4-5 tables. Each table should have several columns with descriptive names and it should be populated with a small number of records (around 20). You may use primary/foreign keys for your tables.
You need to implement a set of operations for your database. These operations should be implemented in SQL. More details on these operations are found in the description of the Inventory database.
Deliverables:
1. ER Diagram
2. Script with all create commands, and some insert commands
3. Operations in SQL.
a. The SQL queries
b. Screen shots with the execution of all the operations showing that your database application actually works (you can take a screen shot of the current window by pressing Alt+PrintScreen keys together. The screen shot goes into your clipboard which you can paste Cntr+V into a document)
Inventory Database
Your inventory database contains information about books, and music CDs. The items are stored in different warehouses in the country. Each warehouse stocks different quantities of the products that you sell. You should store information with details about all the products, the warehouses, and the availability of each product in each warehouse.
Below is a set of mandatory fields for your database tables. However, they are not enough. You willneed additional columns to make it functional and support the inventory operations. Feel free to create your own complete schemausing the columns below and additional columns of your choice.
- Books: ISBN (unique identifier), title, author(s), price, category (fiction, drama, etc.), keywords (to describe its contents), etc.
- Music CDs: ID(unique identifier), album title, artist(s), recording company, price, genre(classical, jazz, pop, rock, etc.), etc.
- Warehouses: address, manager's name, telephone number, etc.
Operations for the inventory database:
1. List all products in inventory (just a few columns for each product)
2. List all details of a product given its unique identifier
3. List each product(s) of a particular author or artist
4. List each product with at least quantity N
5. List each product that is out of stock
6. List the location of the warehouse(s) which stock a product of a given unique identifier
|
What will happen to unemployment and the price level
: What will happen to unemployment and the price level in each of the following situations?
|
|
Determine the maximum amount the contractor
: A contractor must choose between buying or renting a crane for the duration of a 5 year construction project. The contractor uses an MARR of 8%. At the end of the project, the crane can be sold for 21% of its initial cost. The cost to operate and mai..
|
|
Lead to higher level of trade for an economy
: Explain briefly whether each of the following would be more likely to lead to a higher level of trade for an economy, or a greater imbalance of trade for an economy:
|
|
Hyprid-fueled engine and a six-speed transmission
: You have decided to purchase a new automobile with a hyprid-fueled engine and a six-speed transmission. After the trade-in of your present car, the purchase price of the new automobile is 530,000. This balance can be financed by an auto dealer at 3%A..
|
|
Design and implement an inventory database
: This phase is to be implemented by each student individually, without the help of others. You will design and implement an inventory database - Design and implement an inventory database
|
|
Determine the capitalized cost
: A specially built computer system has just been purchased by Progress Greenhouse Products to monitor moisture level and to control drip irrigation in hydroponics beds that grow cluster tradiro tomatoes. Determine the capitalized cost (i.e. forever) a..
|
|
What are the total costs-prices-revenues and profit for firm
: Two physical therapy firms want to merge. The price elasticity of demand for physical therapy is -0.40. Firm A has a volume of 10,400, fixed costs of $50,000, marginal costs of $20, and a market share of 8%. Firm B has a volume of 15,600, fixed costs..
|
|
The minimum value of average variable cost
: For a particular competitive firm, the minimum value of average variable cost (AVC) is $12 and is reached when 200 units of output are produced. For the same firm, the minimum value of average total cost (ATC) is $15 and is reached when 230 units of ..
|
|
An increase in nation interest rate reduces
: Holding other things constant, an appreciation of a nation’s currency causes. Holding other things constant, an increase in a nation’s interest rate reduces.
|