Free

Business Rules and Data Models - Assignment Example

Comments (0) Cite this document
Summary
In this scenario, they can easily find the information about a specific student by entering his/her ID which was allotted to the…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER96.2% of users find it useful
Business Rules and Data Models
Read TextPreview

Extract of sample "Business Rules and Data Models"

BUSINESS RULES AND DATA MODELS Business Rules and Data Models Affiliation Colleges usually want to track the following information in a database:
1. Admission for which class.
2. Group
3. student
4. CNIC (Computerized National Identity Card)/ Social Security Number
5. Date of Birth
6. Father/ guardian occupation
7. Contact information
8. Address
9. Marital status
10. Fee information
11. Religion
12. Nationality
13. Marks obtained in previous class
14. Elective subjects.
Purpose of a database
“A database is a collection of information that is organized so that it can easily be accessed, managed, and updated” (Rouse, 2006).
The basic purpose of a database is to save the information about the students in computers so that college staff could find them in their database. In this scenario, they can easily find the information about a specific student by entering his/her ID which was allotted to the student at the time of admission (Guimaraes, Murray, & Austin, 2007).
The database will allow the database administrator to set some privileges to the students or their parents who can enter or update information their own. By entering this information to the database parents or students can find or see the information that they provided during admission in the college (Guimaraes, Murray, & Austin, 2007).
The use of the database will allow the staff members to find the desired information quickly. Because there is no need to open too many files for finding a specific information. And also there is no need of paper and pencil work, and saving or transferring files from one place to another (Guimaraes, Murray, & Austin, 2007).
By creating a database both colleges and students get a number of benefits. In this scenario, one of the most important benefits is that both can improve their efficiency (Guimaraes, Murray, & Austin, 2007).
Entities and Their Attributes
These are the information which can be collected by colleges for tracking information in a database. The tables given below outlines this information in the form of entities and their attributes:
Information
Information as Entities in Database
Attributes of Entities
Admission for which class
Class
1st year
2nd year
3rd year
4th year
Information
Information as Entities in Database
Attributes of Entities
Group
Group
Science
Arts
Information
Information as Entities in Database
Attributes of Entities
Student
Student_name
First Name
Last Name
Information
Information as Entities in Database
Attributes of Entities
CNIC/ Social Security Number
CNIC
Student CNIC
Parent CNIC
Information
Information as Entities in Database
Attributes of Entities
Date of birth
Dae_of_birth
Month
Date
Year
Information
Information as Entities in Database
Attributes of Entities
Contact information
Contact_info
Mobile Number
Land line Number
Information
Information as Entities in Database
Attributes of Entities
Address
Address
Student Address
Parent Address
Information
Information as Entities in Database
Attributes of Entities
Marital Status
Marital_Status
Married
Non Married
Information
Information as Entities in Database
Attributes of Entities
Religion
Religion
Muslim
Hindu
Christian
Jew
Information
Information as Entities in Database
Attributes of Entities
Nationality
Nationality
No Attribute
Information
Information as Entities in Database
Attributes of Entities
Marks obtained in previous classes
Marks_of_previous_class
Obtained marks
Grade
Information
Information as Entities in Database
Attributes of Entities
Elective Subjects
Elective_Subjects
Subject 1
Subject 2
Subject 3
Business Rules
Given below are some of the important business rules that must be kept in mind while creating a college database:
1. Apply restriction on wrong information.
2. The student must not enter invalid Social Security number in a database.
3. For selecting elective subjects student must select their group.
4. Date of Birth should contain constraint if date of birth is crossed the limit according to requirement.
5. Contact information should follow the format set by the database.
6. By entering all information to the DB students must fill the complete admission form fields or application form fields for the course which he/she applied in college.
Business rules using ERD
1. Students have first name and last name and student have only one SSN and many students have a SSN. Similarly for parents SSN.
2. Students can apply to one group or many groups, similarly many students can apply to many groups.

The Information which should include in the conceptual DB Model
Entities names and their relationship must be included in the conceptual model and the following information should be included:
1. A student can apply to many groups.
2. A student has only one date of birth, and many students can have the same date of birth.
3. A student has only one mobile number and one mobile number is given by only one student.
The Information which should include in the physical DB Model
The physical database model should include primary key, foreign key, table name, column names, and column data types:
Social Security Number
Information
Information as Entities in Database
Attributes of Entities
CNIC/ Social Security Number
SSN
Student SSN
Parent SSN
Primary key: Student SSN
Foreign key: Parent SSC
Table Name: SSN Relation
Column Name: student SSN and Parent SSN
Column Data Type: Number or Int
References
Guimaraes, M., Murray, M., & Austin, R. (2007). Incorporating database security courseware into a database security class . Proceedings of the 4th annual conference on Information security curriculum development. Kennesaw, Georgia: ACM New York, USA.
Rouse, M. (2006, April). Database. Retrieved from TechTarget.com: http://searchsqlserver.techtarget.com/definition/database Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Business Rules and Data Models Assignment Example | Topics and Well Written Essays - 500 words”, n.d.)
Business Rules and Data Models Assignment Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/logic-programming/1659639-business-rules-and-data-models
(Business Rules and Data Models Assignment Example | Topics and Well Written Essays - 500 Words)
Business Rules and Data Models Assignment Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/logic-programming/1659639-business-rules-and-data-models.
“Business Rules and Data Models Assignment Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/logic-programming/1659639-business-rules-and-data-models.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Business Rules and Data Models

Timmers Proposed Business Models

...which add value to the data available on open networks, such as information search, customer profiling, investment advice and the like (Timmers, 1998). Critique of Timmers' Business Models Wirtz et al. integrates some of Timmers' concepts, stating that there are four broad internet business models - content oriented business models, which provide on-line access to content, such as magazines and newspapers on-line; commerce oriented, which offer goods and services on-line; context-oriented, which structures the information found on the web, as opposed to providing content, goods or services; and connection-oriented, which...
25 Pages(6250 words)Essay

Data Rules Summary

...responses, and care for patients as they experience threatening and uncertain situations” (p. 139).Then after the data rules are connected a procedural rule will conform to a model: If stipulation X, is evident, then do Y. The ‘IF’ part of the rule relates to the domain knowledge in the data rules. The ‘THEN’ part brings about some other task.  O’Neill et al. (2004) gave us an example of risk category questions: Who is at risk for X? Then the intervention category question would be: If I suspect X, what do I do? They added that so far, there are 15 categories of grouped rules, which include: emotional...
1 Pages(250 words)Essay

Data and Information System Models

...? Data and Information System Model Information management plays a vital role in the revolution of clinicalmethods and operations. Strong information management goes a long way in the process of adopting and implementing clinical transformation. Quinn, in his article ‘The role of Information management in clinical transformation’, highlights some of the key performance goals essential for a triumphant implementation of clinical transformation. In addition, he underscores on the various requirements and constrains that must be put in to consideration in the selection process of a healthcare system. Quinn draws attention to several requirements that must be put into consideration in the design phase of a...
3 Pages(750 words)Assignment

Data Rules

...’ focuses on a specific type of Decision Support System. This Decision Support System focuses on the problem solving expertise embedded into it by comparing its inputs with facts, rules and procedures already present in its data bank (also referred to as Data Warehouse). The Knowledge Based Subsystem in the DSS uses this data input (that may be mere facts, figures, personal knowledge and business models) to analytically identify any probable problems that may arise, possible decisions that can be made and possible solutions to an issue. The particular DSS under consideration in the said article concerns a knowledge based system that...
1 Pages(250 words)Coursework

Business models

...ORGANISATION’S BUSINESS MODEL: STAKEHOLDER CREDIBILITY ALONG WITH FINANCIAL VIABILITY With consensus on the fact that CEO must be well informed of the company’s business model, there is little agreement on the operating definition of business model. With all innovations, the ground concept of business model remains as Peter Drucker defined that business model shall address the clear customer identification; valued factors by business’ customer and ways to manage to meet customer value demand in cost efficient or profitable way. Concisely,...
3 Pages(750 words)Essay

BUSINESS MODELS AND PLANNING

...Question Difference between a broad business model definition and a narrow business model definition A business model is thetechnique of undertaking a business venture by which an establishment can sustain and maintain itself thus generate proceeds. The business model influences how a company generates money by stipulating the position of the company in the value chain. A Broad Business Model Definition A broad business model incorporates exact proposals with high opinion to the elements and relationships that facilitate...
2 Pages(500 words)Essay

BUSINESS MODELS AND PLANNING

...Business models and planning Discuss why the supply of Strategic information might increase demand and vice versa? Supply of strategic information within a business model is controversial with reference to the quality of demand. At times the supply of strategic information might increase demand because it allows a business to create an open communication between all levels of employees enabling everyone to understand their roles in the production process. This triggers the need for supply of strategic information that would help in harmonizing the efforts of the stakeholders thereby increasing the productivity and thenceforth the demand. The strategic...
5 Pages(1250 words)Essay

Business models group project

... Business Models for Electronic Markets The article that was written by Timmers discusses the various business models thatexist in electronic commerce. The author begins by defining electronic commerce as a form of business that involves the electronic exchange of tangible goods such as physical products and intangible ones such as information (Timmers 1). The author also argues that although there are new business models of conducting business electronically, some techniques of this form of business, for example, Computer Assisted Life-cycle Support (CALS) and Electronic Data Interchange (EDI) were developed long ago in the twentieth century (Timmers 1). This argument indicates that electronic commerce emerged a long time ago... their...
8 Pages(2000 words)Essay

Business Models and Planning

...and mission at the best interest of the society. With the best motives for the society, they can either run a business or none-profit organizations that would quench their social quest. On the other hand, social media movement refers to the use of social networks to serve the society with all kinds of information. The networks transmit messages about the culture, traditions, politics, beliefs, education and bodies of the society. The messages reflect the values and the force for change of the society. The social media used are Facebook, twitter, YouTube, web pages, blogs, Myspace, newspaper, movies, television, radio, journals, books, magazines and billboards among others. All these social media serve to fuel and propel...
2 Pages(500 words)Essay

Business Models and Planning

...Business Models and Planning Canvas framework Compare the Business Models between Airbnb, Crosby Street Hotel and Motel 6 Airbnb Motel 6 Crosby Street Hotel Customer segment Segmented into personal and business travelers. Also segmented into personal and business travelers. Segmented into business travelers unlike the two. Channels Different channels are used to acquire customers. They are online ads, PR and word of mouth. Channels used to acquire customers are through different advertising campaigns in social media, ads and media houses. Uses advertising channels and word of mouth to attract customers....
1 Pages(250 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Business Rules and Data Models for FREE!

Contact Us