Altair Software Entity relationship diagram

Junior (College 3rd year) ・Art ・APA ・3 Sources

Altair Software requires a database to store staff information. There are eight people in the company: one president, two vice presidents, three programmers, and two sales reps. The database must be scalable, meaning it must be able to expand as the organization grows.

This study elaborates on the database completion planning technique. It also includes an entity relationship diagram for the database tables. Aspects such as cardinality and modality for the various relationships are also covered in detail. Furthermore, the reasons for selecting the relationships between each of the database tables are discussed.

Strategy for completing the database (2017) highlights various steps that are useful when planning a database. First, there is need to gather information regarding the information that the database will contain. In this case, employee information was to be stored in a manner that enables scalability. Second, there is need to identify the objects to be stored in the database. With the employee database, tangible employee information was to be stored. Third, with the objects identified, they are then modeled in a visual manner. The employee database is modeled using entity relationship diagrams. Further, the types of information to be stored in each object are identified. The employee database contains raw data column typesto store employee names, categorical columns to classify the positions of the employees, identifier columns to identify each item stored in each table, and the relational columns that are used to link the two columns. Finally, the relationship between objects are identified. With the employee database, the primary keys identified are utilized in creating the relationships between the tables.

Entity relationship diagram (ERD)

Rouse(2017) describes an entity relationship diagram as a graphical representation of an information system which shows the relationship between objects, concepts, events etc. within the system. In a database, the ERD diagram shows the relationships of the sets of entities stored therein. Rainer et al., (2014) opine that while cardinality on the one hand refers to the maximum number of times an instance in one entity can be associated with instances in the related entity, modality on the other hand refers to minimum number of instances that one entity can be associated with instances in the related entity.

Selection of the links between database tables

The selection of the links between the database tables was based on the relationship identified between them. Where a one to many relationships existed between the tables, for instance, between the various departmental details and the towns, it was selected in contrast to the one to one relationship that suited the relationship between the employee details table and the position held by each employee.
One employee could only hold one departmental position e.g. manager, programmer etc. while many employees could live in either Anytown or Sometown.


Rainer, R., Cegielski, C., Splettstoesser-Hogeterp, I., & Sanchez-Rodriguez, C. (2014). Introduction to Information Systems, Third Canadian Edition (3rd ed.). Canada: John Wiley & Sons.

Rouse, M. (2017). What is entity relationship diagram? - Definition from SearchCRM. Retrieved 2 August 2017, from (2017). Developing a Database Plan. Retrieved 2 August 2017, from

Get a price
Academic level
Pages *275 words
Total price
$ 0 .00
$ 0 .00

Prices that are easy on your wallet

Our experts are ready to do an excellent job starting at $14.99 per page

What Clients Say About Us
Our Customers Rated UsGreat
Out of 5 Based on 357 Reviews
I experienced difficult times trying to complete huge number of assignments to my university at the same time and you, guys, literally saved me. Everything was done in time and on the highest level! I really appreciate your help.
Essay, History, 12 pages, 7 days, Master's
First time when I placed an order with you, I just lacked time to do all the homework and it was a lot going on in my family. But today I’m doing it sometimes just for fun – I really enjoy communicating with your Customer Support members and just letting myself being a bit lazy
Yuong Lo Mui,
Literature review, IT, 17 pages, 4 days, Master's
My GPA is 4.0 and I’ve always been doing everything myself, but there is a class which I was about to fail thus my GPA would decrease first time in so many years. I ordered few assignments to be completed with and you did a great job! Thanks to you I still remain one of the best students on campus.
Essay, Politics, 8 pages, 5 days, Junior
I am not used to such services and I usually write all the papers by myself. But this time I got in a very difficult situation and had to order my paper on this website. To my surprise it appeared to be quite good. Thank you, it is really nice service. Think I'll get back to you soon!
Thesis, Management, 34 pages, 14 days, Master's
I am on my maternity leave now, so I spend a lot of time at home taking care of my little son. I’ve decided to get one more higher education degree while I’m spending so much time at home and applied for distance learning in one online college. But caring a baby takes even more time then I excepted so I’m the way too busy to write the complicated masters level research works, but is so-so-so cool! Thank you for that you exist! I don’t know what I would do without you all!
Essay, Education, 15 pages, 8 days, Master's
I am studying and working at the same time and it is difficult to cope with university assignments as I am very tired after the work day. You service is a salvation for me as it helps to do everything on time. I am really happy about it. Wish you everything the best! Especially my lovely writer 109!
Coursework, Religion, 11 pages, 7 days, Master's

We at

work according to the General Data Protection Regulation (GDPR), which means you have the control over your personal data. All payment transactions go through a secure online payment system, thus your Billing information is not stored, saved or available to the Company in any way. Additionally, we guarantee confidentiality and anonymity all throughout your cooperation with our Company.

Try our service with 15% Discount for your first order!   Try our service with 15% Discount for your first order!   Try our service with 15% Discount for your first order!  

Order Now