Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Company A has 10 sales teams operating around the US, based on the region and city assigned

Company A has 10 sales teams operating around the US, based on the region and city assigned

Business

Company A has 10 sales teams operating around the US, based on the region and city assigned. Their products vary from crackers, bars to cookies. Different products have their profit margins. All sales are recorded in the system for analysis.

 What are business rules, entities, and attributes?

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Rules 
Business rules are directions that define (or constrain) the conduct of business activities, according to their most basic description. While business rules and procedural definitions are intended to assist an organization in achieving its objectives, those who lack clear business rules and procedural definitions will often find themselves in a chaotic workplace with inconsistent outcomes, low employee morale, and dissatisfied customers.
1. A micro market's first step
The US is the world's largest market. If you limit your search to New York, Chicago, California, or Florida, you may lose out on greater chances in Boston, Minneapolis, Texas, or North Carolina. It is critical to first determine the consumer type you wish to market to, the places where they are most concentrated, and how they prefer to buy their items. Finding a labor pool is also critical. The city you want to export to or base yourself in is not necessarily the ideal fit. The final point is that every state has various legislation and tax rates, so many may be able to work with you. The regional SACC chambers normally work closely with state governments and officials who can help you discover your ideal location.

Step-by-step explanation

Rules 
Business rules are directions that define (or constrain) the conduct of business activities, according to their most basic description. While business rules and procedural definitions are intended to assist an organization in achieving its objectives, those who lack clear business rules and procedural definitions will often find themselves in a chaotic workplace with inconsistent outcomes, low employee morale, and dissatisfied customers.
1. A micro market's first step
The US is the world's largest market. If you limit your search to New York, Chicago, California, or Florida, you may lose out on greater chances in Boston, Minneapolis, Texas, or North Carolina. It is critical to first determine the consumer type you wish to market to, the places where they are most concentrated, and how they prefer to buy their items. Finding a labor pool is also critical. The city you want to export to or base yourself in is not necessarily the ideal fit. The final point is that every state has various legislation and tax rates, so many may be able to work with you. The regional SACC chambers normally work closely with state governments and officials who can help you discover your ideal location.
2. How to raise investment capital
The quantity of money necessary for a successful investment will vary based on the industry. But, like with most things in life, you get what you pay for. A typical employer should pay at least a year's wage. It is better to invest enough money to ensure success than to use too little and risk failure. Private investors, venture capitalists, and loans are all possible sources of money. Expect a revenue flow 6-12 months after investment, and a profit in 18 months.
3. Creating a market entry strategy
A considerable amount of planning and investment is required to export to the USA. Do not be afraid to hire a consultant - it is probably prudent to do so. Having a firm or someone like SACC who understands the market and the regulations is priceless.
I know my market, have funds, and a plan! Next?
4. Knowing international investment customs, tariffs, and legislation
Any company considering investing must thoroughly research the rules and regulations governing the product they wish to make or sell. The government regulates and restricts the selling of several things. This is another area where expert advice would be very beneficial. However, being an EU member, Sweden is exempt from several US tariffs and regulations.
Discover the Made in America Standard.
Learn more about these rules at Customs and Border Patrol.
5. IP Rights, Contracts and Agreements
You must be careful while selling in America not to sell a product already protected by a US patent. Intellectual property is unique among private property types. It's harder to verify and define. The "intellectual property" of a product belongs to the person who first conceived of it and filed for a patent. Before opening a business in the United States, make sure you have all the necessary documents. Sign contracts with your employees outlining your company's policy on intellectual property.
6. SACC-USA
Through our network of 19 regional chambers, we connect our members with experts, partners, suppliers, officials, and customers. The SACC network can help you set up meetings and events, promote your company in the US, and more. Connect with other Swedish exporters with important insights and connections.

Entity 
An entity set is a collection of entities belonging to a given entity type at a specific point in time. During the creation of an entity relationship diagram (ERD), a name is used to represent the type of entity being represented by the box.
Entities of Various Types
You should also be familiar with the many types of entities, which include independent entities, dependent entities, and characteristic entities, amongst other things. These are detailed in greater detail below.
Entities that are independent of one another
Independent entities, also referred to as kernels, serve as the foundation of a database's operations. They serve as the foundation for all other tables. Kernels are distinguished by the following characteristics:
• They are the fundamental building components of a database system.
• The primary key might be either simple or composite in nature.
• The primary key does not function as a foreign key.
• They do not rely on the existence of another entity to ensure their survival.
Entities that are dependent on one another
Dependent entities, also known as derived entities, are entities that receive their meaning from the meaning of other tables. The following traits can be found in these entities:
• Dependent entities are used to connect two kernels together in order to improve performance.
• They are considered to be existence-dependent on two or more tables if they are found in both tables.

The associative tables with at least two foreign keys are formed as a result of many-to-many relationships.
• They may also have additional characteristics.
• The foreign key is used to identify each table that is associated with it.
• When it comes to the primary key, there are three options:
1. If a foreign key is unique across multiple tables, use a composite of foreign keys from those tables.
2. Make use of a composite of foreign keys and a qualifying column to improve performance.
3. Create a new primary key that is straightforward.
Attributes
Each entity is specified by a set of attributes (for example, Employee = (Name, Address, Birthdate (Age), Salary), which are used to describe the entity.
Each attribute has a name and is connected with an entity as well as a set of legal values that fall under that entity's jurisdiction. The ERD, on the other hand, does not include any information on the attribute domain.
Different Types of Attributes
There are several different types of qualities that you should be familiar with. Some of these should be retained as is, while others should be modified in order to make representation in the relational model more straightforward. The categories of qualities will be discussed in detail in the first part. Later on, we'll talk about how to adjust the properties so that they properly fit into the relational model.
Attributes that are straightforward
Simple attributes are those that are obtained from the atomic value domains; they are also referred to as single-valued attributes because they only have one value.
Aspects that are composite
Composite attributes are ones that are made up of a set of attributes that are arranged in a hierarchy.
Attributes with multiple values

When an attribute has a set of values for each entity, this is referred to as multivalued attributes.
Attributes that have been derived
A derived attribute is an attribute that contains values that have been determined from the values of other elements. The attribute Birthdate can be used to calculate an individual's age. This type of property is referred to as a stored attribute since it is physically saved to the database in this scenario.