Question

1. Advantages and disadvantages of Web-DBMS approach. Discuss the Web as a database platform

2. Compare and contrast ER model and DM.

3. Describe the database design methodology for DW

4. Compare and contrast OLAP and OLTP

Answer 1

PLEASE GIVE IT A THUMBS UP, I SERIOUSLY NEED ONE, IF YOU NEED ANY MODIFICATION THEN LET ME KNOW, I WILL DO IT FOR YOU
AS I DONE MOST OF YOUR ANSWERS, THOUGH WE ARE ONLY ALLOWED TO ATTEMPT ONE ANSWER OR FOUR SUB PARTS, PLEASE GIVE IT A THUMBS UP

1. Advantages and disadvantages of Web-DBMS approach. Discuss the Web as a database platform

ADVANTAGES

• Preferences that get using a DBMS
• Straightforwardness
• In its unique structure, HTML as a markup language was simple for both engineer and guileless end-clients to learn.
• Stage Independence
• Graphical User Interface
• Normalization

DISADVANTAGES

• Unwavering quality
• Security
• Cost
• Versatility
• Restricted practically of HTML
• Statelessness
• Transmission capacity

Web database can arrange individual or business information. A Web database is an database application intended to be overseen and gotten to through the Internet. Site administrators can deal with this assortment of information and present expository outcomes dependent on the information in the Web data set application.

2. Compare and contrast ER model and DM.

ER Data Modeling	Dimensional Data Modeling
Appropriate for Online Line Transaction Processing (OLTP) Application	Recommended for Data Warehousing Applications
Comprises of Entities and Relationships .	Comprises of Facts and Dimensions
High Create/Read/Update/ Delete (CRUD) action	High Select Activity
Information Redundancy isn't wanted	Information Redundancy is wanted
Standardization is recommended	De-Normalization is recommended

3. Describe the database design methodology for DW

Designing of database is most significant obligation of the product experts who are managing the information base related activities. For this they follow the Design Methodology. It causes the originator to design, oversee, control, and assess database advancement ventures.

Design methodology: An organized methodology that utilizes strategies, procedures, devices, and documentation helps to help and encourage the cycle of plan.

A design methodology comprises of stages each containing various advances, which direct the originator in the procedures proper at each phase of the task.

4. Compare and contrast OLAP and OLTP

OLAP	OLTP
Comprises of authentic information from different Databases.	Comprises just operational current information.
It is subject arranged. Utilized for Data Mining, Analytics, Decision making,etc.	It is application arranged. Utilized for business errands.
The information is utilized in arranging, critical thinking and dynamic.	The information is utilized to perform everyday crucial tasks.
It uncovers a preview of present business errands.	It gives a multi-dimensional perspective on various business errands.
Huge measure of information is put away normally in TB, PB	The size of the information is generally little as the chronicled information is documented. For ex MB, GB