What does it mean to say that a database displays

Assignment Help Database Management System

Reference no: EM133399564

Question 1:- Discuss what is a trigger in database, and what is its purpose? Discuss real-word application example of triggers. Please DO NOT write the SQL command. Provide a scenario of real-world application that you will use Triggers.

Question 2:- What does it mean to say that a database displays both entity integrity and referential integrity? And why entity integrity and referential integrity important in a database? Provide an application example to support your discussion.

Question 3:- Read chapter 7 and search reputable external resources and IGU online library and discuss what are Logical AND, Logical OR. Provide real world application examples and discuss when you will use these operators?

Question Discuss what is a trigger in database, and what is its purpose? Discuss real-word application example of triggers. Please DO NOT write the SQL command. Provide a scenario of real-world application that you will use Triggers.

Question 5:- Assignment Description

After reading Henry Book database PP slides answer the following questions:

1) Write Seven (7), SQL statements using this database and describe each query and explain each query. (84 points)

For example, if your query is

SELECT Publisher.PublisherName

FROM Publisher

WHERE (((Publisher.City)<>"New York"));

Your explanation should be: This query will list the publisher's name from Publisher table where Publisher City is Not New York

2) Describe what are the tables in this database and what is/are the relationships between these tables. (16 points)

Q6:- Read chapter 9, IGU library resources and reputable articles/journals and discuss:

What is SDLC and what is DBLC? What are the phases? Are there any similarities?

Q7:- Please read chapter 9 and review lesson slides posted under this week, search IGU online library and reputable resources/journals and describe:

What basic database design strategies exist? Describe Top Down and Bottom up, Centralized and Decentralized Design). Explain how such strategies executed? And what are the consideration to know which strategy to choose?

Suggestion: Use PP slides Chapter 9 Figure 9.14, 9.15 and 9.16 as your guide for this assignment

Q:- 1A BLUE STAR HOSPITAL system has 4 hospitals ( H1, H2 , H3 and H4) . They need your service to establish new data communication Network.

H1 : Fairfax, VA

H2 : Dallas , TX

H3: Los Angeles, CA

H4 : Columbus, OH

WIDE AREA NETWORK REQUIREMENTS (EXPECTATIONS)

Hospitals must be connected to each other
The patient files are going to be located in the main hospital (H1) and will be shared with all computers within system by using the file transfer applications.
WAN Expected data rates between hospitals

EXTRANET DATA RATE REQUIREMENTS

Requested data speed from H1 to H2

10 Gbps

Requested data speed from H1-H3

8 Gbps

Requested data speed from H1-H4

80 Mbps

Requested data speed from H2-H3

12 Mbps

Requested data speed from H2-H4

2 Mbps

Your team will be developing the WAN network design. Prepare your recommendations by covering the following section.

Question 1 Draw the block diagram and clearly indicate the network topology you would prefer to connect all four Hospital sites. You may use USA Map to draw network diagram. Download USA Map from the web and place the nodes on the map and then draw the topology. You must insert the picture of the Network diagram into your MS word document

You must write a) your name b)course number and c) Topology of your WAN on the diagram.

Question 2 All four sites will have 90Mbps connection to the internet. In the WAN diagram you developed in question 1 , incorporate the connection to the internet and provide the new diagram. You must insert the second diagram/picture of the Network diagram into your MS word document

You must write a) your name b)course number and c) Topology of your WAN on this second diagram.

Question 3

What type WAN service (s) would you recommend to lease for each connection to fulfill the Data Rates expectations ?You should prepare a table and write WAN service for each connection among the hospital sites
What you would be recommending for the Internet Access Technology for each site. You would be able to find the local internet service providers

Reference no: EM133399564

Questions Cloud

How dose this article connect to your life : How dose this article connect to your life? How do this article make think about the world? Why was it so interesting and why? How are you going to use

What connections can you make between our current education : What connections can you make between our current education system and the points discussed in the chapter? What elements do you still see/experience?

Which housing policies was rothstein discussing : which housing policies was Rothstein discussing? Why does Rothstein say the housing policies were unconstitutional? To what extent does this argument relate

What life was like before the industrial revolution : Describe what life was like before the Industrial Revolution. What are some things that impact our daily life that resulted from the Industrial Revolution?

What does it mean to say that a database displays : What does it mean to say that a database displays both entity integrity and referential integrity? And why entity integrity and referential integrity important

Describe one successful way sound music is used to engage : Describe one successful way sound/music is used to engage the audience -- use the text to help describe why you think so. Describe one unsuccessful way

Describe how groups and cultures are presented : Describe how groups and/or cultures are presented in all your advertisements. Your analysis is limited to the people in your ads who form groups

How does the optimal policy path look like : How does the optimal policy path look like? Draw the path on a 4 X 4 grid. 2. Does it contain as much right or left turns as the policies generated by the old

Defines the product or service they are serving : Company defines the customers. Company defines the product or service they are serving. Company defines Define the company's values. As per the above

User Account

All Pages