Purchase Solution

Business Rule Identification from ER Diagrams

Not what you're looking for?

Ask Custom Question

DBMS Concepts and Business Rule Identification from ER Diagrams.
See attached file for full problem description.

Attachments
Purchase this Solution
Solution Summary

Solution shows the identification of Business Rules from ER Diagrams.

Solution Preview

Please see the attached file.

An example of a nonserialized item is:
A. computer
B. paper
C. laser printer
D. copier

Please explain.

Each ITEM may be a SERIALIZED ITEM, which is an item that is tracked individually (e.g., a computer server) or a NON-SERIALIZED ITEM, which is an item that is maintained as a group (e.g., screws in a bin). Therefore, the quantity on hand is maintained for the SERIALIZED ITEMs, and a serial number is maintained for non-serialized items.

Paper we generally don't refer singly, we refer to set of papers in reams etc..

The database is based on the ______ that are derived from the database initial study.
A. mission statement
B. tables
C. systems procedures
D. business rules.

I believe this one to be business rules but I am not totally sure.

What is the business rule that the E-R model segment in the below figure is illustrating?

----------------- -----------------
ORDER INV_TYPE
__________ ___________
ORD_ID TY_GROUP

---------------- ----------------
I I
T T
I I
I I
I ...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

View More Free Quizzes
Related BrainMass Solutions

  • Database Design

    ConceptDraw - cross platform software for creating ER (Entity-relationship ) Diagrams DB Visual ARCHITECT - Support UML Class Diagram and ERD ER/Studio - robust, easy-to use ER modeling tool from Embarcadero.

  • Explains why REA diagrams are not appropriate

    REA diagrams are the diagrams for approaching database design, and its objective is to provide the pictorial representation of the problems related to business and accounting (Hall, 2015).

  • Simple Relationship Diagrams: ER diagrams

    The expert examines simple relationship diagrams for ER diagrams.

  • Database Management

    4577 Database Management Please help me with the ER diagrams in detail. Please read details in attached word document: ER-Diagram.doc Database Management is highlighted.

  • Data Modeling Tools in Microsoft Access Database

    Simply put, ER diagrams are visual diagrams that show database information represented as entities and relationships. Relationships tool found in Microsoft Access, reflect what an ER diagram is.

  • Mangement Analysis: Entity Relationship Diagram

    ER-diagrams have three basic elements including entities, attributes and relationships. Entities are the things for which, information is stored. Thus, an entity can be a person, place or event.

  • Reasonable to conclude that an ER visit is related to ability to pay?

    According to research, Hiren has found that indigent patients use the ER as a facility of convenience and not for true emergencies He reviewed a random sample of 140 ER records from the last month to classify if they were seen for true emergencies

  • Dependence diagram

    Draw an ER diagram based on the decomposed tables (in Chen model). Look at attached grade report... Please check attachment. Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.

  • dependence diagrams

    Draw an ER diagram based on the decomposed tables (in Chen model).

View More Related Solutions