You have been tasked to turn these data into a relational database. You will need to build the database and write a report about what you did. You only need to submit the report. It should have the following sections:

a. Introduction – Introduce the business requirements and describe one business rule and one use case you can identify from the scenario given above.

10 marks

b. ER Diagram – Identify the entities and relationships in the scenario given above and draw an ER diagram showing the entities, attributes, relationships, and cardinality. Do not decompose any of the relationships at this point.

10 marks

c. Database Schema – Decompose the design to create a schema to store the data in a suitable normal form (2NF or 3NF). Say which normal form the design is in and justify your choice. List the tables and show the fields, primary keys, and any foreign keys in your schema. Describe any assumptions you have made or any additional fields you have added to your design. Make sure all the primary keys are a sensible choice and introduce new fields if needed. Draw a schema diagram to illustrate your design.

20 marks

d. Create Tables – Create a MySQL database to store the schema that you designed in part c. above. Create the tables using SQL statements and reproduce the code in your answer report. Define the keys and choose appropriate data types and any other restrictions you think are required.

20 marks

e. Insert the Data – Insert the data given above into the appropriate tables. Give a single example of an SQL statement that you used to insert one row of data into one of the tables.

10 marks

f. SQL Queries – Carry out the appropriate SQL queries of answering the following questions. For each query, give the SQL code and the result of running the query on the data in your database. Marks are given by each question.

i. Return a list of all dog names (2).

ii. Return a list of all dog breeds, showing each breed only once (3).

iii. Write a query to count how many dogs have the string “Labr” in their breed (2).

iv. Calculate the average age of all dogs in the kennel (2).

v. Calculate the average age of dogs by breed (3).

vi. Find the breed of dog that has an average age of more than 8 (4).

vii. List all the dog names along with their owners’ names (4).

viii. List all the dogs who have had a vet note recorded. Give the name of the dog and the date of the vet note (5).

ix. List all dogs, giving their name, and if a dog has had a vet visit, give the note for the visit, otherwise, if the dog has not visited the vet, return null in the vet note field (5).

 Write a Audit report for E-commerce (Amazon ) Backup policy, 

Thinks should cover in backup policy like homogeneous operating system environment like Windows, Linus, or Mac OS.

How it is useful, and Importance of the backup policy with two operating systems like Windows and MacOS

Audit Report should in Passive voice, APA format, Number of pages(4-5) without reference 

1. Describe the key elements of the Disaster Recovery Plan to be used in case of a Disaster and the Plan for testing the DRP

2. Briefly Discuss the Internal and external and environmental risks,which might be likely to affect the business and result in loss of the facility. loss of life, or loss of assets. threats could include weather fire or chemical, earth movement, structural failure, energy, biological, or human

3. Of the strategies of shared-site agreements, alternates sites, hot sites, cold sites, and warm sites, Identify which of these recovery strategies is most appropriate for your selected scenario and why

4.for each testing method listed briefly describe each method and rationale for why it will or will not be include in your DRP test plan.

1000+ Words

one set of Bullet Points

APA format

 

in this assignment, you need to animate covid-19 numbers in 4 state in dynamic bar graph settings. You need to read data from a url, https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv .

In the bar graph, randomly choose 4 states and show total number of cases in these state daily in an animated way. It means a frame should  show total number of cases on a given day. The next frame should show next day’s numbers. The animation should update twice a second (interval = 500), i.e., two days of data will be shown in one second. The title of graph should show current date, such as Jun 15, 2020. Both axes should have appropriate title. The animation should start the most earliest date and should stop once all data is consumed. 

Background

In this assignment, you will be designing a 4-bit by 8-bit multiplier. Once completed, you will then
have in your “box” of designs this multiplier function, as well as the elementary design blocks.
Before stating the multiplier design problem to be solved, a comment is appropriate regarding the
already completed 8-bit adder and 8-bit register designs. If you find that you need a 16-bit adder or a 32-
bit adder, you should see that you could use your VHDL code for the 8-bit adder and simply change the
entity statement and architecture statement to create the 16-bit or 32-bit adders. In this manner, you could easily add to your “box” of components by simply making changes in the entity/architecture codes from existing components. This also obviously holds for design of 16-bit, 32-bit, or whatever size registers
needed. In the case of the multiplier design done here, it would be easy, given the VHDL
entity/architecture code for the 4×8-bit multiplier, to adapt that code for an 8×16-bit multiplier. I am
keeping the size (4×8) relatively small so that this design is not overly complicated.
Figure 1 illustrates the multiplication of an 8-bit binary number (A7 A6 A5 …A0) by a 4-bit number
(B3 B2 B1 B0) where A0 and B0 are the least significant bits of those numbers.
(0 0 0 C A7 A6 A5 A4 A3 A2 A1 A0 ) *B0
(0 0 C A7 A6 A5 A4 A3 A2 A1 A0 0 ) *B1
(0 C A7 A6 A5 A4 A3 A2 A1 A0 0 0 ) *B2
(C A7 A6 A5 A4 A3 A2 A1 A0 0 0 0 ) *B3
P6 P5 P4 P3 P2 P1 P0 
P7
Discard
8-bit Product

Figure 1: Illustration of multiplication of 8-bit number by 4-bit number giving 8-bit result
In this figure, the 8-bit number is shifted one place to the left and multiplied by the next bit of the 4-
bit number. To create a square set of numbers, zeros have been added both at the right and left hand
sides. The C entry corresponds to the carry from its line that carries being added into the next column.
The overall product, including the final output carry, consists of 8+4+1=13 bits. In the example in Figure
1, I have chosen to keep the 8 most significant binary bits. Details of other choices are beyond the needs
for this course. Figure 1 shows the need to “gate” the 8-bit number, i.e., multiply the 8-bit number by the
corresponding bits of the 4-bit number as the sum of partial products proceeds. This function can easily
be added to our earlier adder design, as illustrated in Figure 2.
B
A
Mgate
Bin
Cout
Ain
Standard Binary
Full Adder
Cin
(adder)
Sout
(a) Binary full adder with gated input
Mgate
C8out
X7
X1
C(7)
C(2)
X0
0Ó
C(1)
(b) 8-bit adder with gated input A
Figure 2. (a) Addition of gate to binary full adder. (b) Design of gated 8-bit adder
Using 8-bit gated adders such as shown in Figure 2b, an 8×4 bit multiplier can be built as shown in
the Figure below, which implements the additions shown in Figure 1.
CR(0)
H(0)
S0(7)
S0(6)
S0(5)
S0(4)
S0(3)
S0(2)
S0(1)
S0(0)
O0Õ
CR(1)
H(1)
S0(7)
S0(6)
S0(5)
S0(4)
S0(3)
S0(2)
S0(1)
S0(0)
O0Õ
CR(2)
H(2)
S0(7)
S0(6)
S0(5)
S0(4)
S0(3)
S0(2)
S0(1)
S0(0)
O0Õ
CR(3)
S0(7)
S0(6)
S0(5)
S0(4)
S0(3)
S0(2)
S0(1)
S0(0)
H(3)
O0Õ
P(7)
P(6)
P(5)
P(4)
P(3)
P(2)
P(1)
P(0)

Figure 3: 4×8 multiplier design
The inputs A(i) of the adder in Figure 2b are the bits of the 8-bit input data word D in Figure 3. The
inputs B(i) of the adder in Figure 2b become the outputs of the previous adder stage in Figure 3 (with
zeros being entered for the first adder). The “Mgate” input signal to the adder in Figure 2b are the binary
bits H(i) of the 4-bit multiplier in Figure 3.

Assignment Statement
Design of the multiplier requires that we complete the design of the 8-bit gated adder in Figure 2b.

Complete the following steps:
1. Design the gated binary full adder in Figure 2a. When doing this, use your earlier design of the basic
binary full adder as one component and simply add the AND gate to create the structural model of the
gated binary full adder. The two components of the gated binary full adder will be your earlier simple
binary full adder and the AND gate. Do the following.
a. Design the AND gate by writing the entity definition and using a behavioral model of the AND
gate. Call the entity AND2.
b. Give the entity description for the gated binary full adder in Figure 2a. Call this GBFA
c. Write the structural architectural model for the gated binary full adder using its two components
(the earlier binary full adder and the AND2 gate).
2. Design the gated 8-bit binary adder in Figure 2b. Do the following.
a. Give the entity description for the gated 8-bit binary adder. Call this G8BFA.
b. Write the structural architectural model of the G8BFA, using the GBFA gated binary full adders as
components.
Having completed the VHDL description for the G8BFA, you next design the 4×8 multiplier shown in
Figure 3 above. In particular,
3. Design the 4×8 multiplier. Do the following:
a. Give the entity description for the 4×8 multiplier. Call this Mult4x8.
b. Write the structural architectural model of the Mult4x8 component using the G8BFA components.
This will require that you use some care when wiring one G8BFA to the next. Use bit-vectors to
allow use of indices. As you work through this, you will see the pattern of indexing that emerges.
c. Simulate the multiplier for a couple of non-trivial pairs of inputs to verify that it is generally
correct.