Altair Software Entity relationship diagram
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
Technet.microsoft.com (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.
References
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 WhatIs.com. SearchCRM. Retrieved 2 August 2017, from http://searchcrm.techtarget.com/definition/entity-relationship-diagram
Technet.microsoft.com. (2017). Developing a Database Plan. Technet.microsoft.com. Retrieved 2 August 2017, from https://technet.microsoft.com/en-us/library/ms177460(v=sql.105).aspx
Academic levels
Skills
Paper formats
Urgency types
Assignment types
Prices that are easy on your wallet
Our experts are ready to do an excellent job starting at $14.99 per page
We at GrabMyEssay.com
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.