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.