Reference no: EM131086032
This project involves designing and implementing a database system for an organization. The term project is made up of a series of four deliverables, each building towards the finished product. The project requires building a database application for a real-world scenario of your choosing. Some examples include: books, movies, music, computer games, geographical locations, genomic sequences, white water rafting resources, flights, etc. Note that you cannot choose the University database that is used in the text book nor the Customer-Invoice schema that is used in assignment 3. Try to pick an application that is relatively substantial, but not too big. For example, you might want your design to have in the range of 5 to 8 or so entities. You will design schemas for the database, and you will create an actual database using the MySQL relational Database Management System. You will populate the database with sample data, write interactive queries and
modifications on the database, and develop user-friendly tools for manipulating the database.
Step 1: What to submit?
You are required to submit a one-page project description of your application. This is an initial, but reasonably well-thought out, one-page description of the database application you propose to work with throughout the course. Note that you cannot choose the University database that is used in the text book nor the Customer Invoice schema that is used in assignment 3. You may state any assumptions you would like to make. Make sure your submission includes the following:
1- One paragraph description of your application. Little bit of explanation
2- An initial list of tables (at least 5 tables) that will be used in order to represent your application.
3- For each table, propose an initial set of attributes (or fields).
4- The explanation of at least 5 scenarios for queries that need to be answered using your database.
|
Explain demand-pull inflation
: MGE1108 ECONOMICS FOR BUSINESS - After you have completed the table above, use the information to draw/plot the Average Fixed Cost (AFC), Average Variable Cost (AVC), Average Cost (AC) and the Marginal Cost
|
|
Determine the tube surface temperature at the coil inlet
: For the prescribed heat dissipation, what is the required condensation rate (kg/s) and water flow rate (kg/s)?
|
|
Nominate a specific application lifecycle
: In your nomination, you must include information about how the ALM tool supports security requirements throughout the System Development Lifecycle (SDLC).
|
|
What does gdp really tell us about economic growth
: According to the article "What Does GDP Really Tell Us About Economic Growth," located in Topic Materials, Khan discusses the pitfalls of GDP. Describe how these pitfalls have affected the overall economic status of a country.
|
|
Implementing a database system for an organization
: This project involves designing and implementing a database system for an organization. The term project is made up of a series of four deliverables, each building towards the finished product.
|
|
Apply sturm sequences and find distinct roots
: Apply Sturm's sequences and find out exactly how many distinct roots are there for each of the polynomials of problem one
|
|
Calculate velocity of flow assuming cv= .98
: A pilot state tube is used to measure the velocity of water in a pipe. The stagnation pressure head is 6m and static pressure head is 5m. calculate velocity of flow assuming Cv= .98
|
|
Equilibrium quantity and price-consumer surplus
: Consider a market where demand is D: P = 24 – Q and supply is S: P = 2 + Q. 1. Equilibrium quantity Qe is a. 10 b. 11 c. 12 d. 13 2. Equilibrium price Pe is a. $11 b. $12 c. $13 d. $14 3. Consumer surplus CS is a. $50 b. $55 c. $60 d. $60.5 4. Produc..
|
|
What the authors discuss in the readings
: ‘Muddiest Point': This question should highlight the "muddiest point" from the readings - the thing that confused you the most and that you'd like to discuss in class. This response should be in paragraph form, referencing both the page number fro..
|