650-Database Design Components

3DQ1Assessment Description

Utilize Figure 4.3, Figure 4.4, and Table 4.3 located in the textbook for assistance in completing this discussion question.

What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables and columns (physical design) directly?

3DQ2
Programming language, such as JAVA, C, Python, and SQL, are commonly used in electronic health records and databases. Relational databases use structured query language (SQL) programming. SQL statements can be divided into two categories: data manipulation language (DML) and data definition language (DDL). Compare and contrast data manipulation and definition language and provide an example and statement from each category.