This paper contains an analysis of the Petrie's Electronics case in line with the system development terms and conditions. The paper identifies the six entities included in the system, their respective attributes and a brief description of the attributes. Moreover, it also discusses the relationship drawing between the entities and explains the relationships.
Business Systems Analysis
Business System Analysis
In the wake of technological advancements, there is a remarkable development and progression in all sectors of life. Education, political, social and business systems are among the latest inventions in the technological sector. An industry ripping immense benefits from the technological development is the business sector. It provides a vast market for the system developers who work tirelessly to develop systems that perform various activities. The business analyses systems create establish the environment of working and management that is simple and convenient to operate. These systems help in the management and analysis of data and information that concerns the business. The preliminary development of the ERD hopes to develop such system that will work for management of businesses.
The attributes of each of the six entities
The business system that relates to Petrie's Electronic case has six set of entities that govern the range of data that the system can hold. These entities have different types of attributes that will help in collecting the information required. Among the entities, include the customer, transaction, product, promotion, coupon and services. These entities help in directing the attributes present in the data flow diagrams for the system. The attributes associated with each entity are as follows.
The customer entity can take various attributes. These attributes include the customer identification (Id), customer name, age, sex and time of arrival among other types of entries. These entries will all these are possible attributes applicable in the entity of customer. The customer name attribute is useful as it identifies who bought what item. The second attribute is that of age. The age attribute is useful in control and security purposes as some items are not liable for purchasing by people of a certain age, for instance, selling adult things to underage children. Therefore, the age attribute is applicable in the customer entity. Moreover, the sex of the customer can help in keeping a database to determine what sex has a larger purchasing power; hence, influencing the stocking decision making for the business. Lastly, the time factor attribute will record the time of buying of the item, which ensures security as it limits the chances of theft in the business. It also gives the customer safety, as a case of reclaiming product from the business, the customer can just identify the time they purchased the item.
Secondly, there is the entity of the transaction, which describes the process of the transaction. In this entity, it can have various attributes. Among these attributes, include the time of transaction, the form of transaction and the server of the transaction. Briefly, the time of the transaction will record the time the transaction happens. This will ensure a clean keeping of the records of the purchases made. The second attribute of the form of the transaction will record the terms of payment, whether the exchange is goods-for goods, or it is via a visa card or by cash payment. The last attribute possible for this entity is the server of the transaction, which simply records the person serving the customer at the counter. This is for authentication purposes.
The third entity in the system is that of product which consists of the following attributes. These are the product name, the ID of the product, the serial number of the product, price of the product and the quantity of the product. These attributes are substantive in the development of a system that meets the specifications of a standard product entity. The product ID, serial number and name, will help to identify the product in question, indicating which product has what name. Secondly, the attribute of price and quantity help in guiding the customer on what to chose and adequately deliver the gain who others. The attribute for quantification favors most people as the Strife for a good price for the product.
The promotion entity has a checklist of commands; however, the personal setting of the business helps determine the hardship they faced among other criteria. Moreover, the buying people will also determine the promotion aspect of the product. Therefore, this entity will see quality products and an additional service from the workers to continue visiting the governor.
Coupon is useful for persons who do not wish to solve the matters of the transaction with cash. A business that has coupon services helps people to achieve more within a limited time as much as possible. Lastly is the entity of service. The services entity has the attribute of the recording and reporting reports. Therefore, the entity of the services that the system offers is costly. However, with well-developed systems, in which the entity development is well, the attributes of services will thus help in the determination of the products that customers wish to purchase.
The identifier attribute
The identifier attribute helps to categorize the service or the question or entity involved in the subject of the purchasing ability. Among the various attributes used in each of the departments, in the system, include, the attribute of the product ID is applicable for the product identification. This is the most appropriate of all the attributes for identification of the products. The attribute of serial number is also possible as an identifier as each product has a unique number, which only identifies every product separately as we do not sell out. The entity of the customer, many customers can have the attribute of customer name, sex and others but not the key identification key. Therefore, the customer ID will help keep the exclusive set of the details of the customer as useful and identifiable as possible. The entity of promotion may not have a principal identifier as it is only about dependent factors that cause the work of the customer simplified. The third entity of services can also do without an identifier, as it is about the dependent aspects that the person on the outside manages to come and buy or pay for that service. The coupon aspect of the entity does not allow for the application of identifier. However, it needs to have some limitation, as the number of people receiving coupons is many. However, being a promotional dealing the public can keep the opponent for playing. Therefore, the key entities with the need for identifiers in the system are those of the customer the product and customer haves the attributes of Id, which are applicable as strong and quality effective control measure for the linking, and relationship of others.
You’re 80% through this paper. Sign up to read the full paper.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.