Explain the concept of the Logistics of Entity-Relationship diagrams in the management of a database. Mention how the implementation of a Database using the following concepts:
to. Centralization of the Database
   b. Only personal data or information will be shared
 

Part II. Using the following information:

Table 1

 

Social Security             Name             Age                      City
111-11-1111                       Maria              20                        San Juan
211-11-3211                   Juana               31                        Bayamon
223-24-3333             Jacinto             30                        Ponce
434-54-5555             Minga               20                        Las Piedras
543-56-7777             Petraca             30                       Arecibo
 

Table 2
Social Security          Phone                  City
111-11-3333                 787-111-1111          Ponce
111-11-1111                    787-222-1222      Bayamon
434-54-5555            787-343-2020    Arecibo
543-56-7777            787-555-5555      Manati

 

1. Develop a query in SQL which integrates both tables.
2. Develop the following SQL queries:
to. By Social Security that integrates data from both tables
b. By Name that the Social Security and the city is the same for both tables
c. By Age that is less than 30 and from the city of Arecibo
d. By phone where Social Security is the same in both tables

Answer rating: 100% (QA)

Part I Logistics of EntityRelationship Diagrams EntityRelationship ER diagrams are a visual representation used in database design to model and define the structure and relationships between different ... View the full answer