Instructions
During this class, students will work on several practice problems. Some practice problems require the use of drawing tools and software. These tools are used by IT and business professionals to visualize, analyze, and communicate complex problems, systems, and processes. You need these tools to create Entity-Relationship diagram.
Please refer to the “Course Software” tab on Blackboard to explore the recommended tools. You should use online resources from Youtube and Google to find tutorials and learn how to use these drawing software. Feel free to contact the TA and the instructor if you need further assistance.
Practice Problem 1:
Come up with business rules for the scenarios given below:
Scenario 1: Business rules define two entities and one 1:M relationship.
Scenario 2: Business rules define two entities and one 1:1 relationship.
Scenario 3: Business rules define two entities and one M:N relationship.
For each scenario, clearly identify the following: Business rules that define two entities and describe a relationship in both directions Entities Relationship type Justification of the chosen relationship type (use complete, coherent sentences!)
Practice Problem 2:
Using the business rules provided below, list all the entities, and identify each relationship type among the entities. Business rules are defined as follows:
A painter can paint many paintings. Each painting is painted by only one painter.
A gallery can exhibit many paintings. Each painting is exhibited in only one gallery. A painter can exhibit paintings at more than one gallery at a time.
Practice Problem 3:
For the business problems given in Practice Problem 2, draw an Entity-Relationship diagram using the Crow’s Foot notation using your preferred ERD drawing tool (check Course Software). Make sure to include all entities, attributes (add 2-3 hypothetical attributes if not given), and relationships.
Assignment Submission
Save all your solutions in a Word file, type your name and course number in that file, name it M1_2_Practice_Problems.
Sample Solution (Attached Document)
Check the attached document for a sample solution that can help you better understand the submission requirements. Instructions
Throughout this course, you will need to design and implement a real-life relational database for a fictional company. First, you will define the company’s business requirements and design the database schema, showing in detail all the relations (tables), data types, relationships, and constraints to be used in the database. After the design phase is over, you will implement the schema in Oracle by creating the required tables with appropriate data types together with relationships and constraints, and populate all the relations with valid data. Last, you will use your database to retrieve the required data using complex SQL queries.
In this assignment, you need to include the following:
A short description of the company (you can use just one department or business process if the company is large)
Reasons why the company needs a database
Detailed business requirements that describe all entities, relationships, and constraints from the business perspective. Do not include more than 4-5 entities! It is very difficult to design a large database without prior experience. Your database will be revised in the following assignments and you will have a chance to make it more complicated later on.
A detailed description of each entity including the name, purpose, and attributes. Description of relationships between entities. Make sure to evaluate each relationship in both directions!
A list of different users for the database you proposed. Define user categories and describe different types of applications each user would need. Explain what type of interface each user would need.
Explain which DBMS architecture would you choose from section 2.5 of the Fundamentals of Database Systems textbook and why. Why would the other architectures not be a good choice?
Assignment Submission
Write your solutions in a Word file, type your name and course number in that file, name it M1_2_ Relational_Database_Specifications. Your paper will be checked in SafeAssign for originality.
Category: Data Entry
For the advanced statistic you’ve discussed in your paper, perform the following analysis (if possible–there was the ability to do something else in the paper if the sport you wanted to discuss didn’t have a good advanced stat, in that case, just choose another advanced stat from a different sport)
Determine how well the advanced stat is predictable from one year to the next. In order to do this, gather data on at least 40 (and up to about 60) players and find the value of that advanced stat in the most recently completed season and the prior one (though if you used consecutive seasons that were completed, don’t worry about the exact seasons you’re using). In order not to bias the results, pick the players as we discussed in class*.
Then once you have enough players, perform a regression, predicting one year’s advanced stat based on the previous season’s. Discuss the results and interpret them–how much variation is explained using the model, what is the equation that the regression determines, and what do the numbers in the regression equation mean?
Provide the data, regression results, and the (brief–about one page) writeup of the results.
*to have unbiased results, I mentioned to look at teams selected randomly (or at least without picking the best or worst–perhaps by division) and find those players in the most recently completed season who played significant minutes who were starters (so look for them to have played in at least 75% of the possible games played, with minutes approaching starting minutes–or however else you might separate starters from reserve players). Then see if they had met the same criteria (for playing time and number of games) in the previous season, and if they did, inlclude them in the data.
You would then have a table in excel that would look like: (sorry, the formatting is probably bad, but hopefully you get the idea)
Player________Stat (this year)________Stat (last year)
Player A ________ 56 ____________________ 35
Player B ________ 26 _____________________ 29
Player C _________ 15 ____________________ 6
And so on for each of your 40-60 players.
notes from my teacher These are the notes my teacher wrote on the first part. Tynesha- thank you for your Week 3 Course Project Milestone 1 submission. Please find the following feedback on your submission per section: >Sales & Gross Profit Forecast: – work shown – out ot 14 possible figures, your correct # was: 14 >Milestone 1 Questions: – 1 not correct- answer should definitely point out that this sales forecast is NOT very reliable. The data is from a high-risk startup, and the forecast is based upon just 2 years of data. At best, that might be good for a one-year projection, but certainly not for 5 years. Also, the forecast does not take into consideration that the business is changing from residential customers to commercial builder customers, so sales figures from the past are not a great predictor for this forecast 3- not correct- Based on the rather pathetic Gross Profit growth across the forecasted years, no Shark is likely to provide the requested funding. Investors generally expect returns of 20% or higher, and within a few years of their investment. This sales forecast shows a very poor return on the investor’s investment.