Information Systems homework help

/in /by

Part 1:

Please discuss by your own thought and word Short & Firm.

1-What basic database design strategies exist, and how are such strategies executed?

2-   The DBMS does not guarantee that the semantic meaning of the transaction truly represents the real-world event. What are the possible consequences of that limitation? Give an simple example.

 

Part 2:

Response to the post below:

“1- What basic database design strategies exist, and how are such strategies executed?

There are two basic database design strategies:

Top-down design method

  • The top-down design method begins from the general and distributes to the specific. With that being said, the database starts with the required general idea for the system and the designer works the way down to the more specific detail to define the element. The process involves the entity type and its respective attributes.

Bottom-up design method

  • The bottom-up design means the designer starts the design with the specific details and moves down to the general concept of the system. In this method, the designers identify the data elements such as entities and group the entities in the database.

2- The DBMS does not guarantee that the semantic meaning of the transaction truly represents the real-world event. What are the possible consequences of that limitation? Give a simple example.

The database is designed to follow and execute the command given by the user, but the database can only verify the syntactic accuracy of databases such as checking the existence of the database and the accuracy of related attributes in the table. The DBMS can verify the accuracy of syntactically correct transaction that represent the real-world event.

For example, the user enters 1000 units for inventory of product A and the database receives the update of sale record. However, database cannot detect the errors like the user entering 100 units of product A inventory instead of 1000 units. The DBMS will execute the transaction according to the command from users. In this scenario, database will be in consistent state because wrong amount was updated by the users.”

 

Part 3:

View the video associated with this discussion thread and answer the following questions.

https://www.washingtonpost.com/video/national/cuomo-drop-in-coronavirus-hospitalizations-suggest-the-curve-is-flattening/2020/04/09/3b5c156a-4ad0-4a8f-8f96-71ddce481f78_video.html

1) How might you describe the chart, presented in the video, in terms of shape, center, and variation?

2) What type of skewness numbers would you expect to generate from the data used to develop the charts in the video?  How do you know?  What would be your interpretation of those skewness numbers.

3) Describe what a box plot of the charts in the video might look like?  What additional interpretations could a box plot provide that may not be as evident in the charts presented in this video?

4) Name one other type of chart that you might use to represent the data presented in the charts of the video.  Why design elements of this chart contributed to your decision to suggest this chart type?  What characteristics about the information might your selected chart type help reveal to the audience?