Computer Science Homework Help

Objectives:

• Describe database schema components.
• Apply standard diagram notation to data
• Examine the components of a relational database model.

***Based on the above knowledge, discuss the following;

Discussion 1

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

Discussion 2

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

***Make sure to cite your sources.