HomeworkLib
Question

  1. Describe the relationships (identify the business rules) depicted in the Crow's Foot ERD shown in the figure below.Describe the relationships (identify the business rules) depicted in the Crows Foot ERD shown in the figure below. 6. BRAND

business   Operations-Management   
1 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

6.

business rules:

1. One brand includes many products (One to many relationship)
2. one product appears on many lines (One to many relationship)
3. one invoice contains many lines (One to many relationship)

1 0
Add a comment
Know the answer?
Add Answer to:
Describe the relationships (identify the business rules) depicted in the Crow's Foot ERD shown in the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Create a Crow's Foot ERD to include the following business rules for a given company: Each...

    Create a Crow's Foot ERD to include the following business rules for a given company: Each employee can complete many invoices. Each invoice is completed by one employee. Each employee is employed by one department. Each department has many employees. Each customer can generate many invoices. Each invoice is generated by one customer.

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

    Exercise 1: ERD Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. A department employs many employees, but each employee is employed by only one department. Some employees, known as "rovers," are not assigned to any department. A division operates many departments, but each department is operated by only one division. An employee may be assigned many projects, and a project-may have many employees assigned to it. A project must have at least one employee...

  • Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

    Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: In a small IT company, each assignment is related to performing a tech check up or working on a new project. All assignments share common attributes such as the assignment code and the description. In addition, unique attributes are used to describe each...

  • Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

    Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: A company owns three types of vehicles: cars, trucks, and motorcycles. When delivered, each vehicle goes through inspection. Each vehicle creates one record in the INSPECTION table. One record in the INSPECTION table is related to one vehicle. All vehicles share common basic...

  • Based on following business rules, draw a Crow's Foot Model: course may require none or one...

    Based on following business rules, draw a Crow's Foot Model: course may require none or one other course as its prerequisite One course can be a prerequisite for only one other course One course can use as many as 10 resources. The resources can be Web sites, journal articles, images, or audios One resource will be used by at least one course or many courses One resource can have multiple creators, but only the first creator is recorded in the...

  • This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the...

    This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the business rules described below. Write all appropriate connectivities and cardinalities in the ERD. A music store would like to develop a database to manage information about the CDs, or vinyl collection, the customers and transactions information. It stores the relationships between artists, albums, tracks, customers and transactions. Here is the list of requirements for the database: The collection consists of albums. An album is...

  • Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...

    Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and participations. The administrators of Tiny College are so pleased with your design and implemen- tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanc- tioned travel. For example, the...

  • this is about databases and SQL, please help me with this and i promise i will...

    this is about databases and SQL, please help me with this and i promise i will thumbs you up :) let me know if you need more info please try to get this done i will definitely thumbs you up :)) PROJECT TOPIC: Library: Books, Copies of the books, Patrons, Checkouts when creating ERD diagram, the notation must be in crows notation, attached at the bottom is an example of crows foot notation in databases so you can understand. PDF...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT