BCIS 4301 Tarleton State University ER Diagrams & Crows Feet Notation Lab Report Everything provided on the file. Have a lookFor the following four scenari

BCIS 4301 Tarleton State University ER Diagrams & Crows Feet Notation Lab Report Everything provided on the file. Have a lookFor the following four scenarios (two should be familiar!) create separate ER diagrams that include
all entities needed to meet the business requirements, along with appropriate attributes. Each
ERD should:
• Indicate cardinality through the use of proper Crow’s Feet notation
• Indicate all primary and foreign keys
• Indicate strong or weak relationships between entities
• Have “verbs” identifying the relationship between entities (i.e a student ENROLLS in a section)
• On at least one relationship per diagram, indicate exact cardinality due to a business rule
using (x,y) notation. For example, a student can enroll in 0 to 7 classes or a professor can
teach 0 to 4 classes) BCIS 4301 Lab Assignment #2 ER Diagrams
For the following four scenarios (two should be familiar!) create separate ER diagrams that include
all entities needed to meet the business requirements, along with appropriate attributes. Each
ERD should:
• Indicate cardinality through the use of proper Crow’s Feet notation
• Indicate all primary and foreign keys
• Indicate strong or weak relationships between entities
• Have “verbs” identifying the relationship between entities (i.e a student ENROLLS in a section)
• On at least one relationship per diagram, indicate exact cardinality due to a business rule
using (x,y) notation. For example, a student can enroll in 0 to 7 classes or a professor can
teach 0 to 4 classes)
1. You have been selected to create a new database for a small summer camp in Vermont. The
database will track campers, their registration, their payment, their bunk assignment, and their top
three preferred activities. The database should also track camp counselors, their bunk assignments
(one counselor to each camper bunkhouse), and their top three activities they supervise. You should
incorporate any feedback received from Lab 1 into your ERD and you may need to expand the
number of attributes needed.
2. Your next project entails your company creating a database for a small music store. The store sells
products to customers, so you will need a basic sales database that allows customers to buy
instruments, sheet music, supplies, etc. In addition to selling products, the company also arranges
music lessons with local teachers. There are currently 32 teachers that teach a variety of
instruments and charge different hourly rates for their lessons. Some teachers only teach one
instrument while other teachers may offer lessons on multiple instruments. Lessons should be
incorporated in the sales database as a product so customers can “order” them. You should
incorporate any feedback received from Lab 1 into your ERD and you may need to expand the
number of attributes needed.
3. Your company has been hired to create a database for a bus tour company. Your database should
include the tour name, customer name, reservations for a tour, and the guide leading that specific
tour. The owner of the company has said that all tour guides are trained to offer any of the tours
led by the company and may be assigned to different tours each day.
4. Your next project requires you to create a database of cooking recipes for a cooking website. Each
recipe should have instructions on how to complete the dish as well as a link to the ingredients in
each dish. There should be a field that calculates the calories of each dish from the caloric content
of each ingredient. Each recipe should belong to a category of recipe: traditional, instant pot, crock
pot, and air fryer. On your ERD diagram, insert a text box from the Insert menu and type a quick
decision about whether you will store or calculate the value on the fly in your database. Provide a
quick description of why you made that decision.
Submit your 4 Visio file(s) in Canvas by the due date.

Purchase answer to see full
attachment