Question

Describe what an API is and what one is used for. (10 pts)

2. Describe what an SDK is and what one is used for. (10 pts)

3. Describe a difference between relational modelling and dimensional modelling. (10 pts)

4. What does the N in N-Tier Architecture mean? (10 pts)

5. Describe the kind of processing that may occur on an Application Server. (10 pts)

6. Name five ways in which people interact with databases in their daily lives. (10 pts)

7. What is an OLAP database? (10 pts)

8. Name five examples of dimensions of a sales fact. (10 pts)

9. What communication protocol is generally used to communicate between application services in a service oriented architecture? (10 pts)

10. Describe a benefit of dimensional modelling. (10 pts)

11. Describe how two database management systems can be used as a part of the same application. (10 pts)

Answer 1

1. Simply said, an API is a functionality exposed by a programmer to an end user. API stands for Application Program Interface. An API is a set of routines, protocols, and tools for building software applications. Basically, an API specifies how software components should interact. Additionally, APIs are used when programming graphical user interface (GUI) components.

2. A Software Development Kit (SDK) is a bundle of tools and softwares required by developers for developing applications for a specific device or operating system. Some examples of SDKs are Android SDK, Windows SDK, etc.

3. In relational modelling the focus is on identification of fundamental or strong entities involved in the execution of business transactions, while in dimensional modelling the focus is on identification of associative entities that carry business measures.

4. In N-tier, "N" refers to a number of tiers or layers are being used.

NOTE: As per Chegg policy, I am allowed to answer specific number of questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.