Alturomg 10 HE CABly integrity rule, a primary key can uniquely identify a table

Question

Alturomg 10 HE CABly integrity rule, a primary key can uniquely identify a table row if it is blank. d. An insert anomaly occurs when there is no way to update records to a database. e. Semantic data modeling uses a system designer's knowledge of business processes to create tables in 3NF CASE 4-1 Research Project As in all areas of IT, DBMSs are constantly chang ing and improving. Research how businesses are using DBMSs, and write a report of your findings. Address the following issues: 2. Which DBMS products are based on a logical - model other than the relational data model? 3. What are the relative strengths and weaknesses of the different types (relational versus other logical models) of DBMSs? 1. Which popular DBMS products are based on the ne lational data model?

Explanation / Answer

Q1)

Q2) RP_DIST_REP_EXAMPLE from SAP, TEST_LDB

Q3)

Advantages and Disadvantages of using relational databases:-

Advantages:

2. Flexibility: Different tables from which information has to be linked and extracted can be easily manipulated by operators such as project and join to give information in the form in which it is desired.

3. Precision: The usage of relational algebra and relational calculus in the manipulation of he relations between the tables ensures that there is no ambiguity, which may otherwise arise in establishing the linkages in a complicated network type database.

4. Security: Security control and authorization can also be implemented more easily by moving sensitive attributes in a given table into a separate relation with its own authorization controls. If authorization requirement permits, a particular attribute could be joined back with others to enable full information retrieval.

5. Data Independence: Data independence is achieved more easily with normalization structure used in a relational database than in the more complicated tree or network structure.

6. Data Manipulation Language: The possibility of responding to query by means of a language based on relational algebra and relational calculus e.g SQL is easy in the relational database approach. For data organized in other structure the query language either becomes complex or extremely limited in its capabilities.

Disadvantages :

Advantages for a Logical Data Model

Advantages:-

Disadvantages for a Logical Data Model:-

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.