Wednesday, June 5, 2019
Concepts of Corporate Strategy | SWOT Analysis of Apple
Concepts of integrated dodging SWOT Analysis of AppleCorporate StrategyIntroductionMarketing strategists term this a harvest strategy and consider it a no-brainer (Hamel Prahalad, 1994125). Few current headache organisation concepts ar more prostrate to all(prenominal)placesimplification than the growth/ piece of ground work, with its labelling of harvest-homes or divisions or whole companies as dogs, question marks, stars or specie cows (Seeger, 198494). An app atomic number 18nt disadvantage of the intercellular substance was that it assumed that grocery take was reliable indicator of emerging profitability (Calandro Lane, 200730). The in a higher place three quotations all criticise the BCG growth/sh be hyaloplasm and its practicality as a matched tool. This paper discusses the advantages and limitations of the matrix and its cover for Apple Inc. as a competitive tool. It concludes that the BCG matrix does throw away some advantages except is non countenance for all logical argumentes industries and should not be determinationd as a sole depth psychology pretense. In the fast paced competitive modern business world crackment just the BCG matrix for evaluating a follows portfolio move have disastrous consequences.The paper is divided into flipper parts. Starting with an introduction, it moves on to the concepts of integrated strategy, portfolio summary and the portfolio models. The third part discusses some of the advantages and limitations of the BCG matrix. The fourth deals with the implications of the BCG matrix when applied to Apple Inc. ending with the conclusion.Corporate Strategy, Portfolio Analysis and Portfolio hyaloplasm ModelsAlways to be best, and to be distinguish in a higher place the rest. This quote from Homer the 8th Century Greek Poet epitomizes the aim of all organizations. This is where strategy comes in. Strategy is the do-or-die(a)ction and scope of an organisation over the long term, which achieves a dvantage in a changing environment through its configuration of resources and competences with the aim of fulfilling stakeholder expectations (Johnson, Scholes Whittington, 20059). unmatched of the ways of achieving this is through competitive strategy. fit to gate clencher competitive strategy involves positioning a business to maximize the value of the capabilities that distinguish it from its competitors (1980 47). To achieve this, c areful compend of the external and internal environment is required. impression and Porters Five Forces Model hobo be utilise for external analysis. For internal analysis the most comm however used is the seven S framework as tumefy as SWOT analysis, value chain, value chain (supply) analysis and portfolio analysis. The resolve is greater sagacity of the environment in which the business operates.Organizations operate under three levels of strategy. Corporate-level strategy, business-level strategy and working(a) or functional strategy. Corporate strategies deal with the organization as a whole enchantment business strategy focuses on how to compete in a situation industry or product- commercialise segment (Hofer Schendel, 1978 cited in Beard Dess, 1981667). Operational strategy is how the organization accomplishes the strategies delimit come forward in the first cardinal development its several(a) resources. For an organization to be profi circuit board it is important to have effective strategies on all levels unsharedly a successful corporate strategy is crucial to the success of business and operational strategy.The late 1960s and early 1970s saw some(prenominal) conglomerates diversifying into opposite fields. New divisions or (Strategic Business Units) were evolving. The problem management faced was of in effect managing all these diversified building blocks. One strategy could not work for all SBUs as they all experience dissimilar competitor threats, merchandise growth rates and trade shar es. This problem was solved by the creation of the portfolio analysis. Portfolio strategy pertains to the mix of business units and product positions that fit together in a logical way to extend synergy and competitive advantage for the corporation (Daft, 2008249). The aim of the corporation is to have a equilibrize corporate portfolio, so that they fag decide which activities or products to expand,introduce and which businesses to acquire or dispose off. Thus, diversified company portfolios are the normal and indwelling business form for efficiently channelling investment into the most productive use (Henderson, 1977203).The most common form of evaluating the corporate portfolios is the portfolio matrix models. Igor Ansoff, veri give in his result-Market Growth Matrix in the 1950s. He believed that just to retain its relative position, a business blotto essential go through continuous growth and stir (Ansoff, 1957113). He used four possible combinations of foodstuff pene tration, product development, market development and diversification and plot them on a 22 model. McKinsey Co certain a matrix where the variables were market strength and competitive position. Bruce Henderson in the mid 70s using the same matrix principle developed his BCG growth/share matrix model. It had the same 22 matrix but was based on relative market share and market growth and used cash go and the experience curve as a criterion. Arthur D. Little developed another model which used the product life cycle. These latter three matrices form the basis of the assorted portfolio models that have been widely used to structure the strategic be afterning cognitive process of the firm in the 1970s (Coate, 198347).Since then there have been many matrices developed e.g. the GE model which uses ROI for assessing an investment opportunity and Shell which used a similar refined matrix evaluating business prospects along with the competitive position of the company. However, the most commonly used matrix by organizations is still Hendersons BCG Growth/Share Matrix. It has to be taken into consideration however that it is important to see these models as aids to decision make, not a replacement for management choice (Hooley, Saunders Piercy, 200464).BCG Matrix Advantages and LimitationsThe BCG matrix plots SBUs by looking at the relationship between market growth and market share. Henderson divided the matrix into cash cows, stars, question marks and dogs and asserted that only a diversified company with a well balanced portfolio give the axe use its strengths to truly capitalize on its growth opportunities (Henderson, 197037). To show the relative signifi toleratece of the SBU, size is shown in circles which tail end be calculated both from assets employed or sale turnover.The growth/share matrix gained immense popularity among turgid organizations with many SBUs. They could now use the matrix and decide which units to nurture, invest or divest. Its main advantage was its attractive presentation and easy to remember terms. development only two variables it was easy and quick to make as well as cosmos versatile enough to be applied to different brands, products, customers and distribution channels. The matrix became popular with managers who preferred the idea of cash menstruum implications rather than net profit which are more in the accounts domain. The PIMS breedingbase which was developed at the General Electric in the 60s and further developed by the Management experience Institute at Harvard in the early 70s excessively supported this view. Another reason for the BCGs popularity was fashion. It is an idea that is well understood and liked by many mangers and therefore integrity that allows communication between headquarters and strategic business units (SBUs). It has become part of the common business vocabulary (Hooley et al, 200471). Undoubtedly, the simplicity of the matrix was its study advantage but it had its li mitations as well.One of the major problems of the BCG matrix were the claims made by the developers that such a single chart with a project position five years out is sufficient al unrivalled to tell a companys profitability, debt capacity, growth potential, dividend potential and competitive strength (BCG, 20083). According to them the matrix would provide the complete solution but this is an erroneous belief. It does not provide the perfect solution for evaluating a companys portfolio. This is also confirm by Hooley et al who say that if it is used it should be audited carefully to ensure its validity rather than followed blindly (20042). Furthermore, there is no set definition of what an SBU is or what the definition of a market is e.g. a product might be a leader in a local market niche but at the same metre a small player in the global market.The matrix is also difficult to plot accurately using market share and market growth. Organizational strength cannisternot be measured by market share alone, it has to take into consideration other strengths e.g. financial strength, brand equity, exclusive distribution channels or unique product features etc. In the same way market growth is only one aspect of market attractiveness. Using the cash flow resources for evaluation can also be perceived as a flaw. In times of high inflation, cash flow may indeed be the major constraint on a companys action range, but other capabilities such as allot managerial talent, expertise, know how, skilled labor and organizational flexibility are also important (Derkinderen Crum, 1984132). overly, according to Henderson we should kick the dogs, cloister the cows and throw our gold at stars. Only the question mark category demands management thought (Seeger, 198494). This assumption can be criticised as being over simplistic. Dogs, should not be divested off without thought. They can retain that important portion of market share keeping competitors at bay, and also an organiz ation who has a dominant product may deliberately introduce a dog into its portfolio for the same purpose. Sometimes, occasionally it is possible to restore a dog to viability by a creative business naval division strategy, rationalizing and specializing the business into a small niche which it can dominate (Hedley cited in Wit Meyer, 2004322).The human aspects and behavioural implications of the matrix are also overlooked e.g. how managers of SBUs categorize as cash cows react when their hard earned cash is given to other SBUs, or of members within the organization whose brainchild is divested? This can have-to doe with the morale of management and may result in quick turnover of disg elapsetled staff which is not beneficial to the organization. The simplicity of the matrix where an advantage can also be harmful since competitors can easy identify the strategy being used and use it to their advantage. An ex tidy of this is the successful infiltration of the Japanese in the UK m otorcycle industry. Another limitation as Coate says is that independent strategies cant be defined for all possible business units (198352) i.e. a business unit producing multiple products cannot invest in one profitable product and ignore the others. Either they all get investment of all of them have to be divested. in spite of the fact that the matrixs limitations far outweigh its benefits, it is still frequently used by organizations and in certain situations can be used as an effective competitive tool as well. The important thing is that it should not be used as the sole analysis method for decision making. plane the Boston Consulting Group has in recent years admitted that market share by itself does not necessarily mean competitive strength. In a serial publication of articles in the Financial Times in November 1981, Michael Gould of the BCG maintained that it is valuable to be the market leader for branded earnests with the advantage of price leadership and the ability t o outspread marketing and distribution costs over a high volume but economies of scale may be achieved even by a firm that is not the largest producer in the industry (Johnson et al, 200590). It is though, fair to say that the simplicity of the Box makes it operationally recyclable and its ease of understanding makes it a reclaimable operational tool provided its limitations are kept clearly in mastermind (Hooley et al, 200487).Apple Inc. The BCG Matrix1 Profile StrategyApple is a global company operating in the technology industry which contrives, manufactures and markets personal computers, portable music players and mobile communication devices. It was established in 1977 as Apple Computer Inc. specialising in personal computers. Operating in the ever changing high growth market and extreme opposition, Apple began losing its market share to its major competitors including IBM and Hewlett Packard as well as the entry of numerous other PC manufacturing companies determined to enter the highly profitable market.SWOT Analysis(fig 2)StrengthsWeaknessesStrong brand image big-chested financial performanceMedia contentDeclining research and development (RD) investmentOpportunitiesThreatsSmart PhonesBooming MP3 player marketsGrowing personal computers and peripherals marketsIntense competitionDependence on specific suppliersPatent infringementApple was faced with a weakening Mac line, stiff competition and demand for better value by the shareholders. at that place was get hold of for a drastic change in strategy and product diversification was chosen as a mean of entrance other consumer electronic market segments. In the Swot Analysis (fig 2) carried out by DataMonitor, we can clearly see their opportunities in the clever phones and MP3 player markets. In January 2007, the company changed its hollo to Apple Inc. as they diversified into other products.Currently, Apple Inc. in its portfolio owns three SBUs. The first is the Mac range which comprises of d esktop and notebook computers along with their accessories. Secondly, it offers music products and go which include ipod, itunes etc. The third SBU consist of the mobile communication devices i.e. iphone.2. BCG Matrix and Apples Product PortfolioIn the current competitive industry using the BCG matrix offers some benefits for Apple but there are disadvantages too. The flexibility that the matrix offers i.e. it can be used for plotting product portfolio of a firm can be beneficial to Apple. To introduce new products and revamp current ones a company needs vast amounts for investment. Apple needed money for RD which is a major expenditure for companies operating in the technology industry. The Company believes continual investment in research and development is critical to the development and intensifyment of innovative products and technologies (Apple Investor Relations, 20071). in the midst of 2005 and 2007, Apple spent $535 million dollars on RD. Part of this money was obtained by withholding dividend payments for two years between 2006 and 2007. The rest was from divesting within the Mac range. Using the BCG matrix, the decision of which products to invest in and which to divest would have been pretty straigtforward.Market growth for technological products very rarely slows long enough for a product to be figureified as a cash cow. Therefore, most of these products would be classified either as a star, question mark or dog. At the time when Apple changed its strategy it had a large number of computers in its product range which it needed to reduce. The whole of the Mac Range would have been plot with a few top selling products as stars which would have been carrying the whole load of the company with its profits. A few question marks which had low market share but were still making a profit which was being again utilized internally, but had low chances of becoming a star and quite a a large number of products and their associated accessories and softwar e would have been plotted in the dogs quadrant. By divesting in the dogs, Apple would have undoubtedly lost some market share but in introducing new products their aim was to attain market share in other markets. Spending huge amounts on RD, Apple updated and introduced few but better computers like ibook and imac into its product line in direct competition with their competitors.At the same time as update its product line for the Mac range the ipod range can also be plotted on the matrix. The ipod currently holds 77% of the global market share , but to keep up with the current high demand Apple almost every year introduces a new version with more features and divest the oldest version which by that time has moved to the dog quadrant. It also uses the same strategy for the iphone range. Even though iphone is a relative new offering from Apple, it is already facing competition and to maintain and increase its market share Apple keeps introducing newer versions.Therfore, even though the BCG matrix does offer Apple benefits for managing its product portfolio, it negates one of the main declarations of Hendrix that only a diversified company with a well balanced portfolio can use its strengths to truly capitalize on its growth opportunities (197037). For a well balanced portfolio, a company must have cash cows, however, with Apple and its products, the market growth rate never slows enough for a product to become a cash cow. Most of its products are in the star or question mark quadrants, and some are dogs which are then divested. Apple however sometimes does hightail it to retain some dogs, even though Henderson believed that pets are not necessary (197037), and should be divested off, Apple keeps some of its older versions of products because they retain a small share of the market which might be vital to the companies overall market share.3. BCG Matrix and Apples SBU PortfolioHowever using the BCG matrix with Apples corporate portfolio poses quite a few probl ems. First of all the developers claims that such a single chart with a projected position five years out is sufficient alone to tell a companys profitability, debt capacity, growth potential, dividend potential and competitive strength (BCG, 20083), cannot be applied to Apple Inc. Apple operates in a fast changing environment where the introduction of one product can radically change the competitive strength and market share of a company. An representative is Dell Computers who in 2007 lost its market leader title to HP. Within one year HPs market share increased dramatically to 17.6% while Dells managed only 13.9%. Apple comes third with a global market share of 2.6%, but that can change rapidly. Also for Apples iphone the current market share is only 6.5% compared to Blackberry which holds 41% and Palm at 9%, but the iphone is relatively new. It was introduced in July 2007 and immediately took over 28% market share of the US smart phone industry showing competitive strength of th e product. Apple with iphone is challenging the market leaders and its market share is increasing every quarter. Therefore, a five year forecast cannot be accurate for analysing its future position.Also, however, if we plot the Mac computer range using market share and market growth rates, it would be positioned in the question mark quadrant. But that would make analysis difficult since two products of the mac range i.e. the ibook and imac are stars but as a SBU plotted in question marks. To manage all the products together would be difficult since some products require investment and some do not, according to the matrix you plan a unit strategy not an individual one.Once again Hendersons criteria of having a balanced portfolio for success would not be applicable in the SBU matrix either. Currently, Apples ipod business unit is a market leader with majority market share and high market growth and would be plotted as a star, and the iphone and mac ranges would be placed in the questi on mark quadrant. It does not have any cash cows or dogs. A successful organization has to have cash cows from where cash flow is diverted into stars and question marks. The ipod sales at present is generating enough cashflow, not only to sustain itself but the other SBUs as well. If we blindly believe Hendersons assumption then logically Apple should be in dire trouble whereas it is actually increasing its market share and cash flow with all three units.Another drawback of using the BCG matrix would be giving its competitors easier understanding of its strategy. With the companys annual reports and market shares available publically, if competitors like HP and Blackberry know that Apple is using the BCG matrix as the sole analysis method they can easily construct a matrix for Apple and figure out its future strategies.Therefore, even though the BCG matrix could be useful to Apple Inc. for analysing its products strength and could be used as a decision tool, it would not be useful f or future decision concerning its SBUs. It has to be admitted though that the BCG in its simplicity maybe can be more effective in another industry. It can be used as an internal analysis method but using it as the sole decisions making analysis method could be hazardous for the company. This is further confirmed by Seeger who says that no management model can safely substitute for analysis and common sense (198497). Apple would benefit using the SID techniques, risk analysis e.g. the monte carlo risk analysis model as well as personal experience and judgement before making any future decisions for its strategic business units.ConclusionWe have thereof seen how as a competitive tool the BCG matrix has its advantages and disadvantages. The main advantage being its simplicity and ease of plotting, but elegance and simplicity in a theorys presentation cannot guarantee sanity in its use (Seeger, 198493). At the same time the matrix has its disadvantages in not having clear boundaries o f what a market is and the criterion for market share and growth and the effect of external factors on it. To gain a competitive advantage a company aims towards making an outlay of cash now in the expectation of extra cash coming in the future (Dixon, 199421). For that they need to be in a competitive position and know which units to invest in and which to divest. BCG matrix makes this decision easier for managers but it has to be utilized in a carefully evaluated way.The matrix does give an index of SBUs performance in the current market but it is not a model that should be followed without use of other methods of analysis and use of judgment by managers. This can be summarized in the words of Porter who affirms this by saying that the growth/share matrix can be one component of a competitor analysis when combined with other kinds of analysis (Porter, 1980364) or Hooley et al who say that it is clearly inadequate as a complete solution, but is of unchallenged value as a starting point in many analyse (200472). Therefore, not begrudging BCG matrix the benefits it offers mangers it is defective as a sole analysis model for competitive strategy and still needs careful evaluation before any decision can be finalized.BibliographyAnsoff, H. I. (1957) Strategies for Diversification. Harvard Business Review, 35(5)113-124, Online available at http//web.ebscohost.com/ehost/detail?vid=4hid=106sid=2bad248a-b6cb-4c13-81c2-74db4080bfda%40sessionmgr102 (Accessed 15th June 2008)BCG The Boston Consulting Group, (2008). The Experience Curve Reviewed. IV. The Growth Share Matrix or The Product Portfolio. Online available athttp//www.bcg.com/publications/files/Experience_Curve_IV_Growth_Share_Matrix_1973.pdf (Accessed 12th July 2008)Beard, D. W. Dess, G.G. (1981) Corporate-Level Strategy, Business-Level Strategy, and Firm Performance. The honorary society of Management Journal, 24(4)663-688, Online available at http//www.jstor.org/stable/256169?Search=yesterm=corporate-leve lterm=performanceterm=firmterm=strategyterm=business-levellist=hidesearchUri=%2Faction%2FdoBasicSearch%3F wonder%3DCorporate-Level%2BStrategy%252C%2BBusiness-Level%2BStrategy%252C%2Band%2BFirm%2BPerformance%26dc%3D every last(predicate)%2BDisciplinesitem=1ttl=194returnArticleService=showArticle (Accessed 22nd May 2008)Calandro Jr, J Lane, S. (2007) Special Section Winning in your industry new tools and strategies. A new competitive analysis tool the relative profitability and growth matrix. Strategy and Leadership, 35(2)30-38, Online Available at http//www.emeraldinsight.com/Insight/viewContentItem.do?contentType=ArticlecontentId=1596528 (Accessed 2nd May 2008)Coate, M.B. (1983) Pitfalls in Portfolio Planning. yearn Range Planning, 16(3) 47-56, Online available at http//www.sciencedirect.com/science?_ob=ArticleURL_udi=B6V6K-45PMPYS-14_ drug user=10_coverDate=06%2F30%2F1983_alid=760368145_rdoc=3_fmt=high_orig=search_cdi=5817_sort=d_docanchor=view=c_ct=3_acct=C000050221_version=1_u rlVersion=0_userid=10md5=f8879374940c70491a7e8906d1bc6068 (Accessed 24th June, 2008)Daft, R. L. (2008) New Era of Management, 2nd ed. Mason Thomson Higher Education.Derkinderen, F. G. J. Crum, R. L. (1984) Pitfalls in Using Portfolio Techniques Assessing Risk and Potential. capacious Range Planning, 17(2) 129-136. Online available at http//www.sciencedirect.com/science?_ob=ArticleURL_udi=B6V6K-45K4GRJ-9P_user=6649953_coverDate=04%2F30%2F1984_alid=760368145_rdoc=2_fmt=high_orig=search_cdi=5817_sort=d_docanchor=view=c_ct=3_acct=C000010181_version=1_urlVersion=0_userid=6649953md5=4eb70387aca6a81b0bed14dab76607ae (Accessed 24th June, 2008)Dixon, R. (1994) Investment Appraisal. CIMA, rev.ed. London Kogan PageHamel, G. Prahalad, C. K. (1994) Competing for the Future. Harvard Business Review. 72(4) 122-128, Online Available at http//web.ebscohost.com/ehost/detail?vid=5hid=107sid=728905ba-dc97-471c-a829-b8c61346578f%40sessionmgr108 (Accessed 23rd April 2008)Henderson, B.D. (1970). The P roduct Portfolio. Reprinted in Stern, C.W. (ed.) and Stalk, G. (ed.) (1998). Perspectives on Strategy From The Boston Consulting Group, pp. 35-37, John Wiley and Sons, New York.Henderson, B.D. (1977) The Corporate Portfolio. Reprinted in Stern, C.W.and Stalk, G. (eds.) (1998). Perspectives on Strategy From The Boston Consulting Group, pp. 203-205, New York John Wiley and SonsHooley, G. Saunders, J. Piercy, N. (2004) Marketing Strategy and Competitive Positioning. 3rd Ed. Essex prentice Hall.Apple Investor Relations, (2007) Apple Inc. 10-K Annual Report. Available from http//phx.corporate-ir.net/phoenix.zhtml?c=107357p=irol-reports (Accessed 17th May 2008)Johnson, G. Scholes, K Whittington, R. (2005) Exploring Corporate Strategy. 7th Ed. London Prentice Hall.Porter, M. E. (1980) Competitive Strategy. New York The Free Press.Thompson Jr, A.A, Strickland III, A.J. Gamble, J. E. (2007) Crafting and Executing Strategy. 15th Ed. New York McGraw-Hill Irwin.Wit, B.D. Meyer, R. (2004 ) STRATEGY-Process, Content, Context. 3rd Ed. London Thompson Learning.XML Database An Introduction and AnalysisXML Database An Introduction and AnalysisXML, mnemonic of eXtensible Markup words is one of the most extensively used selective information format and is used as a standard for exchange of info over the internet. As large amount of entropy is represented as XML documents, techniques like RDMS have to be used to store and interrogative sentence these XML documents.There are two well know approaches for parsing an XML document to convert into comparative DBMS SAX and DOM parsing. In this research, both these methods are studied and then the performance is compared. Some alternative ways of data structuring and tagging from tables of RDBMS as a hierarchical XML document has been studied. As a final result, the best alternative which willing provide with the best and effective performance for capturing and interrogativeing XML data using RDBMS can be found out.When a la rge amount of data is to be potent into an XML document, it becomes important to execute the request ask and compose the process at XML document. One way is to use XML native data base system. This has two weaknesses 1. eXtended Markup Language resident database system is not ample to save data and it cannot contain the complicated interrogative sentence at relational DBMS.2. It is impossible for the users to access XML documents and data that are stored in a relational DBMS.To spank the above mentioned weaknesses, questioning and storing XML data techniques using RDBMS are used. The steps for this approach are-1. Data or an XML document is saved by making relational table goal.2. XML data is divided by separating them into columns in the presented table.3. SQL Queries are used to get access to the XML document format obtained in RDBMS dta format.To transfer data from XML to data base, the strategy is to use C as middleware. This research can be through with(p) by parsing te chnique with the help of SAX parser or by using XML Tree Class.To do the vice versa, the present format of XML document from relational SQL SERVER 2008 database supported by C script, used as middleware is converted with the help of tagging and structure. All alternatives (outside engine) done by tagging and structuring process implies that a part of the task was done outside the relational database engine.For comparing the XML document and RDBMS from the point of speed in loading the process in the browser following tasks were performed-Searching of the data in the XML document is done with the help of DATA binding technique.Presentation of the XML data from RDBMS is done by searching data from XML document which was saved into SQL database, than with the help of DOM Tree method the result of the query is saved as a XML DocumentDatabase problems in XMLThey are hard to update.We cannot implement the constraints.Its difficult to optimize the xml database.Hard to maintain the consiste ncyData Storage and Data TransmissionThese two are different concepts. In data storage we store data and while storing it we need to check the validity of the data. In Data Transmission we simple transfer the data from one system to the other. XML are generally used for the Data Transmission purpose.COMPARISONRelational DatabaseXML DatabaseMETA DATA DefinitionCREATE duckDEFINE XML SCHEMA application of DATA break in,UPDATECREATE XML DOCUMENTQUERYSELECTXPath ,X oppugn1.2 BENEFITS AND LIMITATIONS OF DIFFERENT DATABASE TECHNOLOGIESSpeed is the major advantage of creating database with objects. In OODBMS (Object oriented Database Management System) data is stored as objects but not in the form relational rows and columns such as in relational DBMS that is why OODBMS is faster than relational DBMS.OODBMS is more applicable than relational DBMS (RDBMS) for some tasks. This is because OODBMS performs many operations using navigational interfaces where as RDBMS uses declarative interfaces. OODBMS follows pointers to implement navigational access to data in an efficient manner.One disadvantage of RDBMS s is we need relational mapping layer to map the entire model for application objects to the database object model, whereas in OODBMS there is no need to match those layers. In RDBMS due to this mapping there may be an impedance mismatch and there is no such problem in OODBMS and it also increases the performance.OODBMS has some drawbacks like-As it is said above OODBMS uses pointers to implement navigational access to data this is one of the drawback as in general purpose queries this will lead to delay the output and also becomes complicated than relationalOne more drawback is that there is no mathematical foundation for OODBMS, unlike RDBMS. This makes OODBMS weaker than RDBMS in backing queries.The difference between data-base centric thinking and oop is in the way it views the world. The first one views the world through a viewpoint which is declarative and set a part-driven. The latter one views through a viewpoint which is behavioural. This is one of the major differences between databases and OOP. Many consider database technology as a failure. Hence attempt are being made in research and industrially to closely integrate database functionality into object programming languages.1.3 DIFFERENT APPROACHES FOR THE DATABASE DESGIGNDifferent approaches for the database design includes data model approach design approach and so on. Starting with the data model approachFor effective project implementation database design is most important aspect thats why should be completed within given time line to give economical approach in project developing phase. Data model construction and updating on change of data deign in necessary as every application will need data storage. It is one of the most crucial parts of an application for developer and user as well. The different normal forms are-1st Normal FormSimilar group should be stored in different tab le and tables should be provided by primary key to identify columns.2nd Normal FormTo protect data redundancy exotic key must be introduced.3rd Normal Form elementary key plays a prominent role making every column in the table related. This makes every column a dependent of the primary key of the table. Those fields not satisfying above property should be stored in a new table with a new key.4th Normal FormIndependent relationship should be removed from the relation database.5th Normal FormMany to many relationships can be related logically thats why its also known as Exists in never-never land.Followed by the data model approach is the design approach which is explained as below2nd and 3rd form designs should be used for large application having enhancement scope. Scalability should be kept in mind during designing phase of application.Third form can ask you to make host of tables with less number of entity which reduces data replication across tables. While public lecture to a f ellow developer i came to know that they used 3rd form as they were quite sure that it would not create dependency problem for their application as they used comma to differentiate primary determine in a defined field of a table.Classes that can be used as data object which contain properties, actually a description and quality of entity element and these properties are introduced by getter and setter, should be designed at the time of creating class diagram for an application. Both object and property shows real life entity. For creating the database tables we need following constraints and relationships to be there in that table so that final database developed will be more effective and understandable. These are explained in the Constrains section under the database design part with the help of query tools.LO2 DEsign and implementation2.1 necessaryThis assignment is to understand the database design concepts, implement the database designed and execute the queries to obtain the required result with the help of SQL Server database. It also helps in developing customer side application to modify, update and view the results through C. Net.Deeveedeezee, the online videodisk shop records the customer enlarge, videodisk exposit which includes title, genres, Studio, classification, actors, directors and other information. It provides the users to rate a DVD using star scaling ranging from 1 to 5 and also allows them to create their own wish list.Our objective is to understand how the database of this DEEVEEDEEZEE is maintained, practically implementing it with the help of SQL Server and develop an client end application that interacts with SQL Server and provides the user the authority to view and land dilate.The WindowsFormApplication1 is the project tile and the client application can be run by opening the solution in MS Visual studio and Debugging the Code. It can be done by clicking on Build-Start Debugging.FunctionDeeveedeezee.com as mentioned abov e provides the online customers various details approximately the DVDs, their reviews, ratings, synopsis and also allows them to create their own wish list. To maintain such a database, it has to be well designed and effectively handled by the executive director or the team of database continuously monitoring and assessing the required information.Every user is provided with unique user-id and password with which they can login and access the required information about the DVDs. They can even provide their comments, reviews and ratings as well which are again recorded under their user-id and are provided when ever required or asked for. Also deeveedeezee handling such large information from the website requires an Administrator or a team working on databases so that it is well managed and maintained. Thus every administrator and the team member again have got their own user-ids and passwords so that they can login into the databases and do their assigned tasks. These discussed det ails are presumed to be handled and the rest of the discussion focuses on the database designing, implementation and development of a client application which interacts with SQL server to provide them the easier access to match and view data from the database.Thus the backend database has got various data rules, definitions and constraints to be handled. Recording distinct information and accessed by different types of users, database has got different tables and views with appropriate fields and attributes. The database design diagram shown below shows the clear picture of how the database is designed, the various tables it maintains, attributes it holds and their properties.DATABASE send off DIAGRAM ERDThe diagram shown below depicts the various tables and its attributes. This design is modified and improved further with the help of Entity race Diagram. The Entity Relationship diagram of the report is as below.The rectangle boxes are considered as entitiesThe ovals are treated as attributes.Rhombus represents relationship between the entities.The diagram represents all entities, attributes and also the relations between the entities.It is a graphical commission of the relations.The ER diagram is a good means of understanding the relationships between the entities and attributes.In the below diagram, different users can be uniquely determined by its attributes like userId, email, firstName etc.User entity is related to DVD by Reviews.The ratings given to the movie by viewers are recorded through Ratings.Comments are the reviews of viewers.DVD on the other hand can be uniquely determined by its attributes like videodiskId, title, studio etc.Role connects DVD and People.Role can be various tasks of people like actors, producer, and director.People have attributes of peopleId and peopleName.dvdDetailsdvdIdtitleretailPricereleaseDaterunningTimesynopsisgenresstudiousersuserIdinitialsfirstNamesurnamedateOfBirthaddressemailmobileNotelephoneNopasswordtimestamps tudio shape Database DesignAddviewUsersAddrolesidpeopleIddvdIdrolewishlistidemailuserIdwishlistCustomersviewdvdClassificationiddvdIdclassificationdescriptionpeoplepeopleIdpeopleFirstNamereviewreviewIduserIdemaildvdIdreviewratingtimestampEntity Relationship Diagram (ERD)peopleNamepeopleIdpeopleRoledvdIdtitleretailPricereleaseDaterunningTimesynopsisgenresstudioDVDRatingCommentReviewuserIddateOfBirthsurNamefirstNameinitialsUsertelephoneNomobileNoemailaddresspassword2.2 4.3 DOCUMENTATION AND implementation OF THE DATABASEDatabase Implementation and Datatype UsageThe designed database discussed with the help of database design diagram and entity relationship diagram are implemented in SQL with the help of MS visual studio.All the attribute and tablenames are in used as per the conventions like using camel case, singular table name and so on. The output tables, conents nd query results are recorded with the help of screenshots and are shown as below set back1 user tableCommentsThe detai ls of the users like firstName,email, DOB, address, contact details are recoderd.In this table Primary key contraint,Not Null constraints are present.Datatypes of each attribute as per the given data rules are being implemented as shown above.Table2 dvdDetail tableCommentsIt stores the all details of DVD like running time ,release date,title and creates an unique dvd id.In this table Primary key contraint,Not Null constraints are presentDatatypes of each attribute as per the given data rules are being implemented as shown above.Table3 review tableCommentsIt stores the reviews and the rating i.e No. Of stars given to the DVD by the user.It has not null contraints ,check constraints which checks that the rating field have value greater than 0 and less than 5,foreign key contrains.email is the foreign key which is refrencing to the primary key of the users table.userId and dvdId the combination of these two is used as a primary key.Table4 people tableComment It stores the name of the people involved in the movie or DVD and gives a unique id to each of them that is peopleId.Table5 role tableCommentIt stores the role of the each people involved in the movie like director,producer,actor etc.It has a foreign key dvdId which refrences to the dvdDetails dvdId.id is the primary key which is a identity with a seed 1.Table6 wishlist tableCommentIt stores the wishlist of each user in comma seprated form.In this table id is the identity with seed 1 and userId is the primary key and email is the foreign key.Table7 dvdClassification tableCommentIt stores the classification of the dvd with a little description about the dvd.dvdId is the foreign key and id primary key and also a identity with seed 1.Constraintsnot NULL ConstraintThis is a constraint which restricts the user from entering the null value or leaving it blank.The user needs to provide the details for that field.It becomes necessary for the user to enter. physique not NULL CONSTRAINTIn the given example id,email,u serId fields can not be left empty. User need to provide these details otherwise it will through error.wishlist can be left empty.Query for this constraintCREATE TABLE wishList( id int NOT NULL,email varchar(100) NOT NULL ,userId int ,wishList varchar(MAX) NOT NULL)Primary key constraintsThis constraint is used to uniquely identify the row in the table.This field is not repeated in any of the other row.Primary key of one table can be used as the reference or foreign key of the other table.Fig PRIMARY KEY ConstraintIn the above example userId is the primary key. All the rows in this table will have different userId.Fig Showing the implication of Primary signalise constraintIn the above figure it is clealy shown that the userId is different for different rows.Unique constraintThis is the constraint used for uniquely identifying a particular column.All the values in a particular column are different.Fig UNIQUE CONSTAINTIn the above figure userId field has a unique constraint.It is a i dentity with a seed of 1.Every time a new row is inserted is mechanically increments the value of the userId which ensures that in userId column no value is repeated.Fig Showing the implication of Unique constraintIn the above figure in userId column no value is repeated . userId has a unique constraint. hostile key constraintThis constraint ensures that the database has a refrential integrity.Foreign key is works on the refrence of the primary key of some other table.QueryCREATE TABLE wishList(id int ,userId int PRIMARY KEY,email varchar (100) references users(email)wishList varchar(MAX))Fig Foreign Key ConstraintsIn the above figure email is the foreign key which refrences the email i.e the primary key of the users table.Check constraintThis constraint makes sure that all values in a column satisfy certain specific criteria.QueryCREATE TABLE review( reviewId int NOT NULL,userId int NOT NULL,dvdId int NOT NULL,review varchar(200) NOT NULL,rating float CHECK (rating0)timestamp times tamp)This check constraint helps in validation of ensuring the star rating to be between 0 and 5.OrCREATE TABLE dvdDetail( dvdId int NOT NULL primary key identity(1,1),retailPrice int NOT NULL,title varchar NOT NULL,synopsis varchar NOT NULL,runningTime int CHECK (runningTime10 AND ratinggenres varchar NOT NULLstudio varchar NOT NULL)This check constraint ensures that the running time to be between 10 and 5000.LO3 Use of Manipulation and Query tools3.1 Benefits of Manipulation and Query Tools in DatabaseManipulation and Query tools in database include those commands and statements that on execution would help in data manipulation. SQL maintains certain standards which includes DML or Data Manipulation Language. The major SQL commands that include in this DML are INSERT, UPDATE, ALTER and so on. These tools or query commands help in modification of tha data and constant updates that have to be made. SQL Server 2008 offers a very good platform that provides access to database and also it provides the query window for executing various commands that include in the Data Manipulation Language. They are very much useful in making it easier for the user to modify the data and update some information. A fine picture of these tools and their functioning can be understood in the sections below3.2 Implementation Query toolsQuery for viewing all DVDs belonging to the Romantic Comedy genre in order of price.Table Initial data in dvdDetails tableQuery-SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studioFROM dvdDetailsWHERE (genres = Romantic Comedy) mark BY retailPriceThe query when executed would result into the table as shown belowTable firmness of the queryQuery for viewing all DVDs belonging to the Universal Pictures UKstudio.TableInitial data in dvdDetails tableQuery-SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studioFROM dvdDetailsWHERE (studio = Universal Pictures UK Studio)Table Result of the queryQue ry for viewing all DVDs in which Johnny Depp or De Caprio have acted.Table Initial data in dvdDetails tableQuery-SELECT dvdDetails.dvdId, dvdDetails.title, dvdDetails.retailPrice, dvdDetails.releaseDate, dvdDetails.runningTime, dvdDetails.synopsis, dvdDetails.genres, dvdDetails.studio, choose.dvdId AS Expr1 FROM dvdDetails INNER JOIN (SELECT DISTINCT NATURAL.dvdIdFROM roles AS NATURAL INNER JOIN people ON people.peopleId = NATURAL.peopleIdWHERE (people.peopleFirstName = Shahrukh) OR (people.peopleFirstName = Amir khan))AS choose ON choose.dvdId = dvdDetails.dvdIdTable Result of the queryView all the DVDs which Steven Spielberg has directed.TableInitial data in dvdDetails tableQuery-SELECT dvdDetails.dvdId, dvdDetails.title, dvdDetails.retailPrice, dvdDetails.releaseDate, dvdDetails.runningTime, dvdDetails.synopsis, dvdDetails.genres, dvdDetails.studio, choose.dvdId AS Expr1FROM dvdDetailsINNER JOIN(SELECT DISTINCT NATURAL.dvdIdFROM roles AS NATURALINNER JOIN people ON people.peopleI d = NATURAL.peopleIdWHERE (NATURAL.role = Director) OR (people.peopleFirstName = Farah Khan)) AS choose ON choose.dvdId = dvdDetails.dvdIdTable Result of the queryView of all the DVDs suitable for a Valentines Gift.Table Initial data in dvdDetails tableQuery-SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studioFROM dvdDetailsWHERE (genres = Romantic)Table Result of the queryView of all the DVDs suitable for children (under 10s) to watch.Table Initial data in dvdDetails tableQuery-SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studioFROM dvdDetailsWHERE (genres = under 10)Table Result of the queryDVDs on the wishlist for a specified customerTableInitial data in wishlist tableQuery-SELECT wishListFROM wishlistWHERE (userId = 1)Table Result of the queryDVDs in order of release dateTable Initial data in dvdDetails tableQuery-SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studioFROM dvdDetailsORD ER BY releaseDateTable Result of the queryDVDs belonging to a specified studio in order.TableInitial data in dvdDetails tableQuery-SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studioFROM dvdDetailsORDER BY studioTableResult of the queryTo add a sample DVD.Table Initial data in dvdDetails tableQuery-INSERT INTO dvdDetails(retailPrice, releaseDate, genres, studio, runningTime, title)VALUES (99, CONVERT(DATETIME, 1990-05-02 000000, 102), under10, Coke Studio, 1100, Tom)Table Result of the queryTableData in dvdDetails table after executing queryAn update query to change the review star rating assigned by a customer to a DVD.Table Initial data in review tableQuery-UPDATE reviewSET rating = 3.5WHERE (userId = 1)TableResult of the queryTableData in review table after executing query3.3 EVALUATION OF QUERY TOOLSQueries can be simple and complex. For the complex queries we make the stored procedures, views and trigger which we can use later in our code and fo r the simple query we can directly embed in the code. Stored procedures contain more than one query and the stored procedure is pre compiled method for accessing the data from the database. Queries including select, insert, update etc are written in the procedures. After committing the query if any error occurs then we roll back and ignore the result of that query.If the meliorate relationship is present between the tables than only we can get the correct result from the dataLO4 Use, documenting and implementing of Relational Database Management System4.1 4.2 TESTING OF THE RELATIONAL DATABASE AND ITs IMPLEMENTATIONQueries in the section 3.2 produce the result right on i.e. the output of different queries are correct and as we know that queries will give the correct output only when the relation between the tables are correct i.e. the relational database is correctly made. Queries in the view section and the also in the client application desired view produce a correct result whi ch shows that the implementation of the relational database is correct.Client ApplicationMicrosoft Visual Studio has been used for developing the client application in C.NET. Our main objective was to provide the user with the facility to add and view the data from the database so that proper updating can be done and relevant information can be provided to the user through the online website of deeveedeezee.com.The prerequisites for this application areMS Visual Studio installed in the computer system with C.NET and SQL server.The MDF file or the database has to be loaded into the application through MS Studio by Data- Add new datasources- Database.Once the database is loaded, the SqlConnection string path has to be modified to the path where the database is located.Every user of this client application is provided with unique username and password through which he can log in into the application. The application only highlights the required and mentioned features in the assignment of turn over and ADD. The figure below represents the Client Application as it looks after logging in successfully.afterlogin client app.JPG Fig Client ApplicationThe user allowed viewing and adding the data, on clicking the respective buttons would be directed to the forms as shown belowview and add.jpgFig View and Add formsOne can view the details of DVDs, Reviews posted by the customers through online website, Ratings provided by them, their wish lists and the user data.One can add up details to be displayed about DVD to the customer, roles played by various actors, actress and other working staff for that particular product, rating as per the reviews and rating awarded by the customers and also new users data.The following sets of figures describe how the data and various details are added to through the client application into the databaseadd dvddetails.JPG Fig Add dvdDetailsOn clicking the submit button, in the coding section the query to insert the details of DVD which inclu des dvd Name or title, Price, Genres, Date of Release of the DVD, Studio and synopsis is executed and the table of dvdDetails is updated as shown above in the query section.add ratings.JPGFig Add DVD RatingsViewing the details of review and rating provided by the customers through online, the user of this client application can rate the dvd accordingly. He has to identify the dvd ID and based on the information he has got he can provide the rating on a scale of 1 to 5. As explained above similarly on clicking the submit button, the query gets exected in the back and the table of concerned gets updated as shown above in the query section.add roles1.JPGFig Add Role DetailsThis helps in providing the customer regarding the cast details of the product.add users.JPGFig Add Users DetailsThis helps in validating the user by adding them into the database.Similarly viewing would allow the user with the following outputFig View of dvdDetailsdvdDetails includes title, price, date of relase and such other features that described the dvd. dvdID is uniquely and automatically generated and is considered as the primary key. From the data available in this table dvds can be classified based on their genre and studio as per requirement.Fig View of RolesThis table helps in updating the online site with the roles played by various persons involved in making this product. The persons can be identified by their unique ids.Fig View of WishlistAs provided online by the customers their wishlist gets updated in the database ad can be viewed for knowing required information about the user and his preferences for future use.Fig View of Users dataUsers or customers using deeveedeezee.com online and th staff using this application, all the details are provided in this table from which one can know about their personal details and contact information to be used for various purposes.Fig View of ReviewsBased on the data provided in the reviews by online viewers, the users of this application can add the modified rating based on data collected from many sources.2.3 Application of a range of database tools to enhance user interfaceIn all the above view forms, GRIDVIEW t
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment