Discussion: Compare and Contrast Data Manipulation and Definition Language
Discussion: Compare and Contrast Data Manipulation and Definition Language
Discussion: Compare and Contrast Data Manipulation and Definition Language
Start Date & Time Due Date & Time Points
Jan 27, 2022, 12:00 AM Jan 31, 2022, 11:59 PM 5
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.
The purpose of this assignment is to build upon your database project proposal by creating the database
schema components. A schema is a logical grouping of database objects, such as tables, indexes, views, and
queries that are related to each other.
To complete Part 2 of the Database Project Proposal assignment, write a 750-1,000-word essay that contains
the following information:
1. Restate your database project; describe its goal and objectives.
2. Describe the purpose of the database schema for your project.
3. Write out the process associated with your business rules relating to your database.
4. Create a data dictionary that contains no less than fve entities. Select and design an entity-relationship
diagram (Crow, Chen, UML); Note: There are a variety of ER modeling software programs on the market.
Microsoft Visio, OmniGrafe, LucidChart, and MySQL are few of these programs that provide free trials to
create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word,
PowerPoint Shapes, or SmartArt.
Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: Discussion: Compare and Contrast Data Manipulation and Definition Language
5. Focus on one or two areas of your design that seemed especially difcult to develop and provide a brief
assessment of the difculty you encountered in modeling.
6. Discuss the project’s limitations and possible extensions.
This is an ongoing project and feedback from the instructor at every stage will help you to improve your fnal
project.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student
Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar
with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is
located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the
master’s degree level:
F1: Health: Does
F2: Information Science and Technology: Does
Page 8 Grand Canyon University 2022 © Prepared on: Jan 10, 2022
F4: Health Information Science and Technology: Does
Topic 3 DQ 1
Start Date & Time Due Date & Time Points
Jan 27, 2022, 12:00 AM Jan 29, 2022, 11:59 PM 5
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 benefts or disadvantages of ER diagrams? Why bother with logical design and not just create
tables and columns (physical design) directly?
