Question

In: Computer Science

Why business rules are important for a good database design? Give 3 examples of business rules...

Why business rules are important for a good database design? Give 3 examples of business rules in academic environment.

Solutions

Expert Solution

Business Rules are used every day to define entities, attributes, relationships and constraints. Usually though they are used for the organization that stores or uses data to be an explanation of a policy, procedure, or principle. The data can be considered significant only after business rules are defined, without them it’s just records, but to a business they are the characteristics that are defined and seen by the company. Business Rules help employees focus on and implement the actions within the organizations environment. Some things to think about when creating business rules are to keep them simple, easy to understand, keep them broad so that everyone can have a similar interpretation. To be considered true, business rules must be in writing and kept up to date.

Bussiness rules are set of approval guidelines or framework within an organization.They simplify daily operations of any organizations.From any engineering perspective, a bussiness rule is a set of reusable bussiness logjc.

3 examples of bussiness rules in academic environment

1.A student must and should have minimum 80 percent of attendance to appear for exams.

2.A student must score 50 out of 100 in order to pass in a subject.

3.The max number of lower grade subjects that a student can have is 3.


Related Solutions

Why is atomicity in database design important?
Why is atomicity in database design important?
Why is expanding not always a good business decision? Give examples of problems on achieved economics...
Why is expanding not always a good business decision? Give examples of problems on achieved economics of scale? How can they be overcome? Are they always apparent? Reply in 600 words
Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw...
Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document. Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab: Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In...
Create a database design with the following rules. List down all the entities and attributes and...
Create a database design with the following rules. List down all the entities and attributes and draw out the relationships. List all the business rules. 1. A person can have multiple accounts (Track individual accounts, Trusts, IRA, 401k, HSA, etc) a. Not all accounts must be through brokerage 2. Multiple brokerages (Fidelity, Vanguard, ect) a. Multiple accounts with different brokerages b. Multiple types of accounts allowed at each broker 3. Categorization of investments (Large Cap, mid cap, small cap, Bonds...
a) Give 5 good examples of Regular language. b) Give 5 good examples of Regular Grammar.
a) Give 5 good examples of Regular language. b) Give 5 good examples of Regular Grammar.
Define the term “relevant range.” Why is it important to managers? Give examples.
Define the term “relevant range.” Why is it important to managers? Give examples.
Data Modeling and Database Design (Database Concepts, Eighth Edition) The relational model is the most important...
Data Modeling and Database Design (Database Concepts, Eighth Edition) The relational model is the most important standard in database processing today. Why do you feel that this model has continued to be successful in the world of IT? What would happen if large corporations decided to reject this theory, and store their data using a non-relational model? Are there any success stories where this has happened?
Give some examples of mass-spring important in everyday life describe why it would be important to...
Give some examples of mass-spring important in everyday life describe why it would be important to understand the amplitude, period and frequency of these systems. Did this project change the way you think about how trigonometry can be applied to real world? state what ideas changed and why. If this project did not change the way you think, write how this project gave further evidence to support your existing opinion about applying trigonometry. Be specific.
In the world of database design and building it is very important to define Primary keys...
In the world of database design and building it is very important to define Primary keys in each table. The text this week talks about primary keys. What are they and why are they so important to a properly functioning database?
Why is the Fundamental Theorem of Calculus so important? Give examples on how the method of...
Why is the Fundamental Theorem of Calculus so important? Give examples on how the method of substitution works with definite integrals. What integrals lead to logarithms? Give some examples.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT