───✱*.｡:｡✱*.:｡✧*.｡✰*.:｡✧*.｡:｡*.｡✱ ───
Q4-4. What are the components of a database app?
A database app typically has a database which includes the actual data in tables or collections; a database management system (DBMS) such as MySQL, PostgreSQL, MongoDB, etc; application logic, which is code that handles the processes in a language like Python, Java, JavaScript, etc; the user interface which is the front-end that users interact with (such as a website or dashboard); and middleware which connects the UI to the application logic with the DBMS.
Q4-5. How do data models facilitate database design?
Data models provide a blueprint for designing a database. They help visualize entities, attributes, and relationships, which makes it easier to structure the data. Data models improve communication across team members and ensures that the database supports the business needs.
Q4-6. How is a data model transformed into a database design?
Data models are transformed into database designs by converting entities to tables, attributes to columns, and relationships to keys (like foreign keys). Designers use normalization to reduce redundancy in the database and define constraints so the rows are accurate.
Q4-7. How do NoSQL DBMS differ from relational DBMS?
NoSQL DBMS differ from relational ones in structure and flexibility. Relational DBMS use structured tables and strict schemas, whereas NoSQL systems use flexible formats like documents or key-value pairs. NoSQL is better for large volumes of unstructured data and scaling horizontally, which is popular for modern web and big data apps.
───✱*.｡:｡✱*.:｡✧*.｡✰*.:｡✧*.｡:｡*.｡✱ ───