Relational Database Assignment Example | Topics and Well Written Essays - 750 words

Relational Database - Assignment Example This assists the user in matching the data with the help of common characteristics contained in the data set including the relation or tables. Relationships play a role in making the data more organized and manageable. This helps the user in perceiving the real concept of design of the database. This also increases the integrity of data through proper arrangement of the data which is logically related into distinct relations. Thinking about the efficiency of database and relationships is an essential component of the normalization process (yaldex.com, n.d.). A relationship is a prime component of the relational database as it develops an association between the logically related pair of tables. The data contained by each of the two tables is the bonding agent between the pair of tables. Relationship if properly defined promotes relationship-level integrity, that in turn ensures the reliability and strength of the relationship (eTutorials, 2012). In addition to that, relationships mak e it possible for the user to perform algebraic operations upon the tables. Division of the elements of a data into the related tables is one of the most challenging tasks of designing a relational database. Once the user is all set to begin work with the data, the user depends upon the relationships among individual tables so that the data can be pulled together in purposeful ways. For example, information about a particular order is of no use if the user does not know the customer who has placed it. Nevertheless, the customer and the information about his/her order are not stored in the same table. Instead of this, the user stores the customer data and the order in two tables that are interrelated. The very relationship between the tables is used to view both the order and the customer data simultaneously. Relationships are the cornerstone when the normalized tables play the role of foundations of the relational database Relationships also help prevent the redundant data in a rela tional database (Microsoft Support, 2011). Defining Relationships between Two Tables A very essential characteristic of the database design is the use of relationships between tables. Defining relationships between tables is very essential for efficient working of the system. â€Å"Relationships between tables are often missing for performance reasons† (Olson, 2009, p. 111). Relationships between two tables are defined through the database system which depends upon matching the values contained in the two tables. When matching values are located, the database system retrieves data from the two tables so that a virtual record can be established. For example, let’s suppose an individual wants to view all the perfumes made by a certain brand. In this example, the database system would locate matching values between the tables of Perfumes and Brands. It is noteworthy here that in a vast majority of cases, the record which results is dynamic that essentially means that chan ges which are made to the virtual record normally identify the path to the underlying table. The matching values that the database system finds include the foreign and primary key values. It is not necessary for a relational model to base the relationship upon a primary key. The user can make use of any candidate key from the table. However, the standard practice requires the use of primary key only. When the primary key of one table is put into another table, a foreign key is formed. All a user needs to do is add the field of the primary key as a foreign key to the

Honda Marketing Communications Case Study Example | Topics and Well Written Essays - 1000 words

Honda Marketing Communications - Case Study Example Honda focuses on every aspect of marketing, not only on promotion and sales techniques, to persuade customers to buy but also on target market, marketing mix and the effective marketing strategy (Kotler & Armstrong, 2001) because successful marketing results in stronger products, happier customers, and bigger profits. Moreover, customers recognize the importance of knowledge in relation to the product being purchased. Several consumer behavior researches testified to this fact. Wong (2000) argued that a customer evaluates a product or a service. Such action is based on the customer's reaction from the using the product or service, which means that the product or service should leave a good perception to the customer's contentment. Frederick and Salter (1995) explained that it can be ensured that a customer is satisfied by taking into importance the value package, which includes: price, product quality, service quality, innovation, and corporate image. Others also stated the importance of maintaining or establishing a uniqueness of the product, while also understanding customers and what pleases them (Denton 1993). Customers should also understand the product and be allowed to set their own standards in order to be satisfied (Frederick & Salter 1995). Of all the components of a marketing plan, perhaps the most overlooked but most critical element is the definition of the target market. According to Claravall (2000), it is a homogenous group of people or organizations that a company wishes to appeal to. There are two basic targets for a product or service: the user and the non-user segments. Thus, there are also two business and marketing decisions that the company must decide upon in light of the basic targets. The first is to cultivate the present market alone while the second is to go after non-users. The former can inspire consumer loyalty which is an important factor in the survival of any business. In introducing new car models of Honda will categorize its target market into two market segments: (1) the Honda cars users or those who have already tried the product, and (2) the Honda cars non-users. Honda cars users are further classified into (a) males and (b) females in order to differentiate the market appeal and competitiveness of the offered products in terms of sex as well as the specific users of the four specified models in order to determine the competitiveness of each product per se. the Honda car non-users, on the other hand, are further grouped into (a) those who do not use cars in general, and (b) those who use other car brands. These market segmentation schemes according to product use will provide important information regarding the overall competitiveness of the Honda Cars as well as viability and opportunities for encouraging car non-users to not just try any other average cars but to choose Honda Cars among others. Moreover, companies now face the challenge of making its target consumers respond accordingly to their marketing efforts and those who understand its consumers' responses will have a great competitive advantage (Kotler & Armstrong, 2001). In this light, the Honda management as well as the advertisers will keep in mind the differences that are distinct between and among the Honda Cars target market based on