Question? Call Us  +1 (817) 546-4770

INFO6001 Database Management

Academic Anxiety?

Get an original paper within hours and nail the task

156 experts online

Free Samples

INFO6001 Database Management

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

INFO6001 Database Management

0 Download3 Pages / 648 Words

Course Code: INFO6001
University: The University Of Newcastle

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Questions:
1. Write all possible business rules for the above case study. 2. Create an ERD (using a specialization hierarchy if appropriate ) that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule. 
Answers:
Introduction 
The granite sales company is a growing company and has a number of employees and they are allocated n various departments however the company keeps the details of the employees and the departments as well.
There are various employees in one department but the employees are only allocated in one department, there are two major categories of employees who are either salaried, hourly or contract employees.
The salaried employees can as well act as sales people who get commissions on top of their monthly salaries and their annual salaries are recorded in the system, however the sales commissions on sales and profits are all captured in the system.
Below are the various tables obtained from the granite sales company scenario.

Department(DepartID, department_name, mail_box_number, office_phone)
Employees(Employees_NO,Name,address, telephone,type, DepartID)
Hourly_Employees(HourlyID,hourly_wage,target_weekly_work_hours, Employees_NO)(Kahate, 2013).
Salariedemployees(SalaryID, yearly_salary_amount, Employees_NO)
Salespeople(SalesID, commission_percentage_sales, commission_percentage_ profit, Employees_NO)
Contract_Employees(ContractID,beginning_date,end_dates,billing_rate,

Employees_NO)
Possible business rules
Below are the various business rules for the granite sales company.

The company can have many departments.
The company can have many employees.
One department can have many employees (Carlos, 2017).
One employee belongs only to one department.
There are many types of employees.
Salaried employee can be salespeople.
The salespeople cannot be salaried employees.
Salespeople get paid on sales and profit commissions.
Employees can be salespersons.
Employees can be hourly workers.
Employees can be contract workers.

The granite sales company Entity Relationship Diagrams (ERDs) 
The entity relationship how the various entities relate with each other, however in this case the database had been implemented using the SQL query below.
SQL query
CREATE DATABASE `granite` ;
use granite;
CREATE TABLE `granite`.`Department` (
`DepartID` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Department_name` VARCHAR( 30 ) NOT NULL ,
`Mail_box_number` INT( 20 ) NOT NULL ,
`Office_phone` INT( 20 ) NOT NULL
) ENGINE = InnoDB; (Kumar,2011). 
CREATE TABLE `granite`.`Employees` (
`Employees_NO` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Name` VARCHAR( 30 ) NOT NULL ,
`Address` VARCHAR( 20 ) NOT NULL ,
`Telephone` INT( 20 ) NOT NULL ,
`Type` VARCHAR( 30 ) NOT NULL ,
`DepartID` INT( 20 ) NOT NULL,
FOREIGN KEY (DepartID) REFERENCES Department(DepartID)
) ENGINE = InnoDB; 
CREATE TABLE `granite`.`Hourly_Employees` (
`HourlyID` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Hourly_wage` INT( 20 ) NOT NULL ,
`Target_weekly_work_hours` INT( 20 ) NOT NULL ,
`Employees_NO` INT( 20 ) NOT NULL,
FOREIGN KEY (Employees_NO) REFERENCES Employees(Employees_NO)
) ENGINE = InnoDB; 
CREATE TABLE `granite`.`Salariedemployees` (
`SalaryID` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`yearly_salary_amount` INT( 20 ) NOT NULL ,
`Employees_NO` INT( 20 ) NOT NULL,
FOREIGN KEY (Employees_NO) REFERENCES Employees(Employees_NO)
) ENGINE = InnoDB; 
CREATE TABLE `granite`.`Salespeople` (
`SalesID` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Commission_percentage_sales` INT( 20 ) NOT NULL ,
`Commission_percentage_ profit` INT( 20 ) NOT NULL ,
`Employees_NO` INT( 20 ) NOT NULL,
FOREIGN KEY (Employees_NO) REFERENCES Employees(Employees_NO)
) ENGINE = InnoDB; (O’Neil, 2011). 
CREATE TABLE `granite`.`Contract_Employees` (
`ContractID` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Beginning_date` INT( 20 ) NOT NULL ,
`End_dates` INT( 20 ) NOT NULL ,
`Billing_rate` INT( 20 ) NOT NULL ,
`Employees_NO` INT( 20 ) NOT NULL,
FOREIGN KEY (Employees_NO) REFERENCES Employees(Employees_NO)
) ENGINE = InnoDB; (Sudarshan, 2016).
Entity relation
Below is the entity relationship diagram implemented using the draw.io indicating the database entities, attributes,entitie’s relationships, cardinality and optionality of various relationships that are described by the business rules.  
Reference
Swamynathan,S.(2010). An Introduction to Database Systems. Pearson Education: New York.
Sudarshan.S.(2016). Database System Concepts. McGraw-Hill Education:India.
Kumar.S.(2011).Database Systems Concepts, Designs and Application. Pearson Education: New York.
Carlos.C.(2017).Database Systems Design, Implementation and Management. Thomson Learning-Course Technology: New York.
O’Neil.E.(2011). Database Principles, Programming and Performance. Harcourt Asia Pte. Ltd: New York.
Kahate.A.(2013). Introduction to Database Management Systems.Pearson Education: New York.

Free Membership to World’s Largest Sample Bank

To View this & another 50000+ free samples. Please put
your valid email id.

E-mail

Yes, alert me for offers and important updates

Submit 

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

UploadUnique Document

DocumentUnder Evaluation

Get Moneyinto Your Wallet

Total 3 pages

PAY 2 USD TO DOWNLOAD

*The content must not be available online or in our existing Database to qualify as
unique.

Cite This Work
To export a reference to this article please select a referencing stye below:

APA
MLA
Harvard
OSCOLA
Vancouver

My Assignment Help. (2021). Database Management. Retrieved from https://myassignmenthelp.com/free-samples/info6001-database-management/business-rules.html.

“Database Management.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/info6001-database-management/business-rules.html.

My Assignment Help (2021) Database Management [Online]. Available from: https://myassignmenthelp.com/free-samples/info6001-database-management/business-rules.html[Accessed 18 December 2021].

My Assignment Help. ‘Database Management’ (My Assignment Help, 2021) accessed 18 December 2021.

My Assignment Help. Database Management [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/info6001-database-management/business-rules.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

Be it selecting Human Resource Research paper topics or drafting a human Resource Management Assignment or referencing HRM assignments, we do it all. We provide proper conclusion and reflective statements citing the means and methods one took to solve the problems.By Consistently linking the praragraphs and citing from famous works, we keep your assignments structured and updated. Place order for premium Human Resource Management assignment solutions with us.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next

Need an essay written specifically to meet your requirements?

Choose skilled experts on your subject and get an original paper within your deadline

156 experts online

Your time is important. Let us write you an essay from scratch

Tips and Tricks from our Blog

PROJ6016 Employer Based Project

Free Samples PROJ6016 Employer Based Project .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} PROJ6016 Employer

Read More »

PPMP20009 Marking Rubric

Free Samples PPMP20009 Marking Rubric .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} PPMP20009 Marking Rubric

Read More »