Home

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.