Reference no: EM131442010
Question One
Explain the different database structures in database management system (DBMS)
Question Two
What are the roles of OSI layers to transmit data from one computer to another computer?
Question Three
Royal Wallace, a UK-based transportation company, is a global leader in the rail equipment and servicing industry. Its wide-range of products includes passenger rail vehicles and total transit systems. It also manufactures locomotives, freight cars, bogies, and provides rail-control solutions.
Because of the structure of its business, the Royal Wallace company has a presence in several countries across Europe and in North America, including the USA and Canada. And, each of these country-specific sites has its own dedicated legacy system such as SAP-based systems in UK and Germany, Oracle financials in Canada, and so on.
These legacy systems are acting as independent data silos with absolutely no kind of data-sharing happening between them. If the German SAP system wants to procure something from any of its vendors, it does so by using some kind of manual process at its end. The same scenario is replicated for all the other systems, too. And, this is leading to a lot of data duplication taking place.
For example, if two different systems are using the same vendor (say, Vendor A) for procuring white board markers, this vendor (Vendor A) information is getting stored at both the legacy systems. Also, this kind of scenario makes it impossible to leverage existing information across multiple systems.
The various systems at Royal Wallace company are based on different platforms. And, the applications running on these systems are used to exchange data in various different formats with the outside world.
Most of these were proprietary formats that each of these applications had created as per their own requirements over the years; there was no single standard approach that had been followed. And above all, as most of these formats were in existence over the past several years, the system owners were very reluctant to replace them for a common standard format/template.
Royal Wallace understands that, to survive the competition in today's fast paced economy and to reduce its time-to-market, it needs to put an integration solution (EAI) in place as soon as possible. The integration model should integrate all the existing legacy systems irrespective of the platforms and operating systems that these systems are based upon.
The model should take care of the various data formats that would pass through this integration scenario and apply the necessary transformation, translation, and data validation rules upon them. And last, but definitely not the least, this integration solution should be scalable enough such that any new system could be easily plugged into this solution in the future with minimal changes.
The integration model should provide:
Integration between the various legacy systems
Automated process for procurement of goods
Data transformation to one common data format and translation logic according to the prescribed rules
Data transformation
Persistent storage mechanism for the data
Validation of business data to a certain extent
Connectivity to various drop zones and databases
What industry is Royal Wallace involved in?
How widespread is the Royal Wallace organization? Why is this a challenge?
What benefits will the new system provide?
What challenges must the new system overcome to get the benefits?
|
How planning is playing a major role in helping my team
: In the next few paragraphs I will demonstrate how planning is playing a major role in helping my team to be successful in providing education to clinical and administrative staff at a system level delivering tools needed.
|
|
What was wal-mart original strategy for creating value
: Wal- Mart, the discount merchandiser, began by putting large stores in small Sunbelt towns that its competitors had neglected. The company then wrapped its stores in concentric rings around regional distribution canters.
|
|
Analyze current job market compensation plans
: Analyze current job market compensation plans and pay scales in comparison to Astra Zeneca. Explain how team members will use lessons learned.
|
|
What is the amount of the special contribution
: Milos wants to have 220,490 dollars in his investment account in 9 years from today. He expects to earn a return of 17.04 percent per year in that account.
|
|
Explain different database structures in database management
: Royal Wallace, a UK-based transportation company, is a global leader in the rail equipment and servicing industry. Its wide-range of products includes passenger rail vehicles and total transit systems. It also manufactures locomotives, freight car..
|
|
Discuss the concept of traits and behaviors
: Search for 3-5 news stories on ethical breakdowns by current leaders. Discuss the events in the context of why the breakdowns occurred. Was it due to a wrong style, such as using charisma when it did not work? Discuss the concept of traits and be..
|
|
Testing of advertising commercials
: Marketing research has been around for more than a century. In the early days, marketing research was little more than a spin-off of the Census Bureau data. AfterWorld War II, psychology began to play a more integral role in marketing research, an..
|
|
What is the present value of any coupon
: Bond A has a coupon rate of 15.81 percent, a yield-to-maturity of 12.55 percent, and a face value of 1,000 dollars; matures in 16 years; and pays coupons annually with the next coupon expected in 1 year.
|
|
How has the technology been received accepted or rejected
: How has this technology been received, accepted, or rejected? Why? Is it feared or favored? What is the attitude toward change? How are the developers trying to sell the technology to the general public?
|