Entity Essays

Mystical Entity

So much for my existence on this plane. On this two-dimensional matrix, I’m no more than a mathematical expression, a cold statement of the location 3,5. However, is that all I am? I suspect there is another hidden dimension, one more axis which gives me yet another value – my consciousness. I do not know in which direction this axis is extended, for my understanding is limited to the two dimensions of length and breadth. A third dimension is a…

Read >>

Relationship Diagram (erd) for the Following Scenario

A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople. A salesperson can be an agent for many customers. A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. When the order is made for number of inventory items, the date and the amount is recorded. An inventory item may be listed on many orders. An inventory item…

Read >>

Point of Sale System

One of the big houses today in Brgy. Guadalupe San Carlos City is owned by the Libre family. Mr. and Mrs. Adonis Libre have three children, namely Clyde, Lanie and Bonnie. They had a convenient store at Bryg. Guadalupe before they had built their new house at the year 1999. Later on their convenient store were replaced with more than one enterprise in San Carlos City, such as the C & B electronics which named after the siblings Clyde and…

Read >>

Petrie Electronics Case

1. The entities Report, Purchase, and Employee could be added. Report consolidates the account details of a customer. It involves recent purchases, coupons history and points summary. Purchase shows a record of what the customer buys. It logs the coupon usage, list of products purchased and the date of purchase. Employee would be the person working for Petrie Electronics and currently monitoring the transactions and services. 2. Coupon- special promotion created for a specific customer. Customer- someone who buys products….

Read >>