Assingment2 Essay

Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is

When it comes to the data model, there exists a relationship that has three different representations for the reason that database requires the relationship between the tables. It goes hand-in-hand with one another without the relationship the tables would have no purpose. The information cannot be repetitive in order for the each table to work and provide the specific database that is related to the information. In different ways the tables in the Huffman Trucking Fleet Truck database

One of the main components of a database is characters. Characters are letters, numbers and punctuation marks. You are using characters when you are typing a sentence for example. Another main component would be fields. Fields separate data in defined fields. When data is being entered even if you don’t have an answer for all fields a space is still left but it would be blank. If you have ever seen an excel spreadsheet that would give you an idea of how data is lined out into different fields. Records are a main database component as well. Records are a group of fields that are about one thing. An example would be social security numbers in a database of patients. Each patient would have a social security number and each social security number is in a field. That field would have the same information which is that patients social security number even though every ones is different and there would be many listed depending on how many patients was in the database. Gartee, R. (2011).

2. Analyze the main advantages and disadvantages of using data analytics within the industry or company that you have chosen.

An AutoNumber field or auto incremented key in a table are used to give unique values which make each record unique.

A table typically has a column or combination of columns that contain values that uniquely identify each row in the

foreign key is the id of a record in a different table. This is done through

Passenger Relation: passenger number, social security number. Voyage Relation: passenger number, cruise number. b.) Primary keys Ship Relation: ship number Cruise Relation: cruise number Port Relation: port name, country Visit Relation: cruise number, port name, country Passenger Relation: passenger number Voyage Relation: passenger number, cruise number Alternate keys Ship Relation: ship name Passenger Relation: social security number c.)

The attributes further define the property. Some relationships between the entities can share more than one attribute and others share only one. The relationship diagram 1.1 will illustrate how the entities and attributes are linked together. Below is a list of the attributes for each of the entities in the database:

4) Designate relationships and attributes from the source data. Relationships are derived from ingredients, pill imprint information

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.

The tables, which contain data stored in rows and columns are made using SQL. Before storing data, it is essential to identify relationships among them. This is done so using an Entity-Relationship diagram which is a graphical representation that identifies relationships among the various tables.

The datatypes of the linking keys or the primary kay can sometimes lead the programmer or the developer to confusion.

Attributes are usually characteristics of entities, and the particular value of an attribute is called a data item, and this can be located in the fields of the record describing an entity. Database keys are important to a database management system because it is a field in a table that is used to classify a record. Database keys matter because database management systems often have trouble confirming that records are not made twice. Look at it this way, if you sign up for fantasy football for ESPN, and then forget that you signed up and then try and sign up again, this is where database keys should help you. The database key will make sure that you won’t get another email informing you that you signed up because it will recognize your email, and this will keep you from receiving multiple emails about you signing up for fantasy football. Database management systems provide a primary key as well, and this key is a field inside the database table that exclusively identifies each record. Each of these records inside a table must have an exclusive entry in the primary key field. The primary key always makes a distinction between records so that records can be effortlessly and correctly accessed, organized, and manipulated (MindTap). An example for using primary keys would be using worker records as the primary key, and this would guarantee that every worker is identified only one time, and when a worker uses email addresses as the primary key for

But attributes with highlighted foreign keys and primary keys which is not included in the conceptual data model.