Question

In: Computer Science

A co-worker reviews a database design you’ve been working on . In it, they notice that...

A co-worker reviews a database design you’ve been working on . In it, they notice that you include the following in your customer entity:

Customer Name (Frist, Middle Initial Last)

Customer Address

i.Street address

ii.City

iii.State

iv.Zip

….

Your co-worker argues that having the City is unnecessary duplication of data, as if you know the zip code, the city can be determined. They also argue that your design violates 3NF (because of the inclusion of both City and Zip).    In addition to your desire to tell him to …, you also want to answer the specific questions. Namely, does this design violate 3NF, and if so why?   If it does violate 3NF, what would it look like (in terms of Entities, Attributions, and Relationships) of the model that doesn’t violate 3NF.   Finally, if it does violate 3NF, what would your rationale be to keep it as is?

Solutions

Expert Solution

S = sparse(A)example
S = sparse(m,n)example
S = sparse(i,j,v)example
S = sparse(i,j,v,m,n)example
S = sparse(i,j,v,m,n,nz)example
Description
example
S = distributed(A) converts a full matrix into sparse type by squeeze out any zero components. If a matrix contains several zeros, changing the matrix to distributed storage saves memory.
example
S = sparse(m,n) generates associate m-by-n all zero distributed matrix.
example
S = sparse(i,j,v) generates a distributed matrix S from the triplets i, j, and v such S(i(k),j(k)) = v(k). The max(i)-by-max(j) output matrix has area assigned for length(v) nonzero components. distributed adds along components in v that have duplicate subscripts in i and j.
If the inputs i, j, and v area unit vectors or matrices, they need to have an equivalent variety of components. as an alternative, the argument v and/or one among the arguments i or j will be scalars.
example
S = sparse(i,j,v,m,n) specifies the dimensions of S as m-by-n.
example
S = sparse(i,j,v,m,n,nz) allocates area for nz nonzero components. Use this syntax to portion additional area for nonzero values to be stuffed in when construction.
Examples
collapse all

Open Script
Save Memory victimization distributed Storage

Create a ten,000-by-10,000 full storage unit matrix.

A = eye(10000);
whos A
Name Size Bytes category Attributes

A 10000x10000 800000000 double

This matrix uses 800-megabytes of memory.

Convert the matrix to distributed storage.

S = sparse(A);
whos S
Name Size Bytes category Attributes

S 10000x10000 240008 double distributed

In distributed type, an equivalent matrix uses roughly zero.25-megabytes of memory. during this case, you'll be able to avoid full storage fully by victimization the speye operate, that creates distributed identity matrices directly.
Sparse Matrix of All Zeros
Open Script
S = sparse(10000,5000)
S =

All zero sparse: 10000×5000

Sparse Matrix of Nonzeros with such Size
Open Script
Create a 1500-by-1500 distributed matrix from the triplets i, j, and v.

i = [900 1000];
j = [900 1000];
v = [10 100];
S = sparse(i,j,v,1500,1500)
S =

(900,900) ten
(1000,1000) one hundred


Related Solutions

Database __________ which is the logical design of the database, and the database _______ which is...
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time. a) Instance, Schema b) Relation, Schema c) Relation, Domain d) Schema, Instance
You’ve just been called for an interview for an executive position at HLT Co. A member...
You’ve just been called for an interview for an executive position at HLT Co. A member of the panel asked you the following question: You are the Chief Executive Officer for HLT Co. Your chief financial office (CFO) and Controller are not in agreement regarding an expenditure of $750,000. The CFO wants to capitalize it while the controller is arguing that it should be expensed. Assume that chief officers are paid a bonus based on reported income from operations and...
You’ve been working as a staff auditor for E&Y for the past couple of years. Your...
You’ve been working as a staff auditor for E&Y for the past couple of years. Your firm decides to put you on the audit of Blizzard Entertainment Inc. While Blizzard is new to you, your firm has been auditing them for a number of years. Before you start working on the audit you learn that your recent romantic partner works for Blizzard in their accounting department (up until that point you had been so hot and heavy you had never...
True or False: Logical database design is the process of modifying the physical database design to...
True or False: Logical database design is the process of modifying the physical database design to improve performance. The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization. Multivalued attributes are not permitted in unnormalized data. A many-to-many binary relationship in an E-R diagram requires the creation of a total of three tables in a relational database. A one-to-one unary relationship in an E-R diagram requires the creation of a total of...
As an EHS Manager for Aggie Refining Co, you’ve just been informed of a tragic contractor...
As an EHS Manager for Aggie Refining Co, you’ve just been informed of a tragic contractor fatality on the HF alkylation unit of your refinery. What are your internal & external (e.g., OSHA) reporting responsibilities?
You have been accepted as an intern at an IT start-up. In a database design session,...
You have been accepted as an intern at an IT start-up. In a database design session, you see that phone number, post code and some other attributes have been defined as numeric datatype. Do you think it is the correct decision? If not, suggest the reasons why this is not appropriate.
Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw...
Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document. Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab: Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In...
A worker of mass 85 kg has been doing repairs on a building, working from a...
A worker of mass 85 kg has been doing repairs on a building, working from a ladder of mass 35 kg, which has its center of gravity at its midpoint. Wrapping up his workday, the worker starts to move the ladder when he notices that he left his 15-kg toolbox attached at a point 0.75 m from the top. In a hurry, he re-positions the ladder carelessly, with its top resting at 8.0 m above the ground and its base...
Mr. Bud. He is a construction worker that has been working on the Cape Cod Canal...
Mr. Bud. He is a construction worker that has been working on the Cape Cod Canal for the past ten years. He has been working outdoors in the direct sunlight where the temperature is 95 degrees Fahrenheit and humidity is 80%. He's sitting at the bar at 4 PM drinking 16 oz. Bud Lite beers with an equal number of bourbon shots. He's not eating the salty bar snacks because he is watching his weight although he's on his third...
Based on the structured way you think about project design in your company, you’ve been made...
Based on the structured way you think about project design in your company, you’ve been made the team lead of a project. If you execute it successfully, you’ll reap the rewards. You’ve convened a team representing different functional groups in your company and the team has come up with several design alternatives (named A-C), which you’ve describe to your manager. You’re working hard one day when your manager rushes into your office and say...: Your manager: “OK, I just had...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT