Reference no: EM131326159
Enterprise/BIM Project
Goal - To enable students to experience the process of building a non-trivial database-backed web application.
Tasks
1. Choose any area that interests you - this does not necessarily have to be about business. Here are a few examples: Library system, Car rental system, Theater ticket sales system (like Ticket Master), Airline reservation system, University registration system and Inventory management system -- these are just examples and you can choose any area that interests you. You will be building an application to help manage whatever application area you have chosen.
2. Develop a project description along the lines of the three ERD review problems that I had posted earlier under "Unit 8: Database design 4". Separate the contents into numbered points. If you submit a rambling long paragraph or essay, I will not be able to go through it.
3. Develop an ER diagram for your chosen area - use Oracle SQL Developer Data Modeler.
a. Your ERD needs to have at least 8 entity types and at least one of them must be an associative entity type.
b. Having a unary relationship will be a bonus, but is not essential.
c. Every integer primary key must be "autonumber"
4. After you complete the ERD and generate the schema, use the documents (not yet posted) APEX-3-creating-an-application.pdf (to be posted under unit 11), APEX-4-creating-simple-pages.pdf (to be posted under unit 11) and APEX-5-adding morefeatures.pdf to (to be posted under unit 12) complete your project.
5. Build an application in APEX (some of these points will become clear only after you have done the earlier steps):
a. You can choose any theme you like.
b. Your application should have the ability to maintain (add, modify and delete data) all your main tables (the ones which are not associative entity types). You should have at least one master-detail form described in the hands-on exercises).
c. You must use lists of values for every foreign key attribute
d. On every form, you should have user-friendly labels
e. On every form, you should display the primary key value as a display-only field.
f. I will provide instructions later on exactly what you will need to submit for the project.
Your project report should be a Word/PDF document containing the following:
1. Project description (as in the project description posted earlier)
2. The logical ER diagram for your project
3. Screenshots of all the pages of your application (be sure to have at least 3 rows of data for each entity type)
4. Workspace name, user id and password for your APEX workspace
5. Your application's name in APEX.
What is the equilibrium quantity and price
: A large country named H is considering an export subsidy to promote the industry that produces good X. The country's excess supply curve is P=2000+2X. The world's excess demand curve is P=5000-10X. a.) What is the equilibrium quantity and price of..
|
Rules regarding relationships between american options
: Determine if any violate the rules regarding relationships between American options that differ only by exercise price.
|
Budget constraint showing the trade-off
: A college student has two options for meals: eating at the dining hall for $6 per meal, or eating a Cup O'soup for $1.50 per meal. His weekly food budget is $60.
|
Calculate the thermal efficiency
: This is called preignition. Take r equal to 9 and, ϒ equal to approximately 1.3 (because it is a mixture) and calculate the thermal efficiency.
|
Building non-trivial database-backed web application
: Goal - To enable students to experience the process of building a non-trivial database-backed web application. Develop an ER diagram for your chosen area - use Oracle SQL Developer Data Modeler
|
Determine the lower bound of the call
: Determine the intrinsic value of the call.- Determine the lower bound of the call.- Determine the time value of the call.- Determine the intrinsic value of the put.
|
Number of dollars per japanese yen
: Let the exchange rate be defined as the number of dollars per Japanese yen. Assume there is an increase in U.S. interest rates relative to that of Japan.
|
Identify the appropriate arbitrage opportunity
: Suppose that the current stock price is $90, the exercise price is $100, the annually compounded interest rate is 5 percent.- Identify the appropriate arbitrage opportunity and show the appropriate arbitrage strategy.
|
Discuss about the advertising messages and marketing
: Discuss about the advertising messages and marketing,integrated marketing communications and media choices,channels of distribution and logistics.
|