Access over 20 million homework & study documents

Final Copy

Content type
User Generated
Subject
MySQL
School
Columbia Southern University
Type
Homework
Rating
Showing Page:
1/3
Question 1
The Cartesian product, also known as a cross-join return, generates all ordered pairs of the
given set in a set theory. The cartesian product is also termed a collection of all ordered pairs
of two given sets where, from one set, elements of the first pairs are chosen, and the second
pair of elements are chosen from the other set. Cartesian product is computed for only two
pairs of SPOs whose random variables are disjoint participating.
Cartesian product can be applied in many representations and real-life objects. Cartesian
product is a general concept manifested in computing and programming in several ways. Most
programmers use the concept, although they don't necessarily realize it. As a database
manager, the Cartesian product will assist me in computation because it is used exactly like
mathematics, and it applies matrix application. For instance, when two sets A {X,Y,Z} and B
{4,5,6} are given, A X B is the cartesian product for the set of all pairs (a, b) (A,4), (A,5),
(A,6), (Y,4), (Y,5), (Z,4), (Z,5), (Z,6). Where a is an element in A while b is an element in B
In addition, the Cartesian product will help me display computer images because most
computers images are displayed as pixel, which is a raster of point. The coordinates are
elements of a Cartesian product ordered in pairs. I will represent images by colouring the
points corresponding to the elements of a Cartesian product subset in the raster.
Cartesian product strategy will be applied as a technique for hiding HTML file schemes
because it is a less costly computation technique. The hiding technique is essential in research
issues, especially when delivering secrete data. Through the strategy, the suitable receiver will
be able to extract secret messages from the HTML file after the source code of the stego HTML
file has been passed. It will also assist in generating the pairs of special blank codes using the
Cartesian product. This will enable the replacement of blank characters according to secret
bits, that is, using the selected unique blank character code

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3
Question 2
Database design
The tutorial defines database design as the process of transitioning used to work with recursive
relationships using SQL.
When describing item relations with attributes, simple attributes are translated into an entity
consistent with the symbol of the tool. However, transitioning from a Data Model to a Database
involves several more steps to identify the database for attributes. To successfully implement
the data model, first is to create a table of entities appearing in the data model. The table should
have a descriptive name and a set of attributes that describe the entity. To complete the table,
several vital tasks are needed for the satisfactory completion of the database. One of these tasks
is the specification of the primary key. Second, one should specify the column properties such
as type of data, null status, default value, and data constraints. Finally, the structure of the table
may require re-evaluation according to the needs of the databasefor instance,
denormalisation of the table or altering the table's design.
Database normalisation
From the tutorial, normalisation is the organization of the data into multiple related tables to
minimise data redundancy. Normalization eliminates redundancy making use of storage. The
presence of data redundancy increases the size of the database, which may lead to insertion,
updating, deletion problems, thus increasing the appearance of destructive anomalies.
Normalisation will solve the issue by breaking the data into separate, logical and independent,
but related data. By doing so, the redundancy problem is solved through normalisation.
Normalisation can be achieved through the first, second, and third standard forms.
To sum up, I chose the two tutorials because they explain the topic covered with relevant
detailed information. In addition, the tutorials have practical demonstrations accompanied with

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
Question 1 The Cartesian product, also known as a cross-join return, generates all ordered pairs of the given set in a set theory. The cartesian product is also termed a collection of all ordered pairs of two given sets where, from one set, elements of the first pairs are chosen, and the second pair of elements are chosen from the other set. Cartesian product is computed for only two pairs of SPOs whose random variables are disjoint participating. Cartesian product can be applied in many representations and real-life objects. Cartesian product is a general concept manifested in computing and programming in several ways. Most programmers use the concept, although they don't necessarily realize it. As a database manager, the Cartesian product will assist me in computation because it is used exactly like mathematics, and it applies matrix application. For instance, when two sets A {X,Y,Z} a ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents