My coursework for ISC 110

This web page explains binary numbers, or base 2, and octal numbers, or base 8. In it there is an explanation about how they relate to one another in comparison to base 10 as well. There is a table at the bottom that makes it easier to understand the conversion.

The assignments below are based off of metadata. Metadata is data about data. This includes information about all kinds of files, such as, JPG, PDF, mp3 and others. People are very uneducated about metadata. Metadata also has EXIF data that goes with it. EXIF stands for EXchangeable Image Files. This includes JPG files in particular. EXIF has information about all kinds of things, such as GPS location, what kind of camera, or smartphone you used, if the flash was on and many others. This topic derived my experiment. My experiment is about the GPS location of a persons phone when they take a picture, and if Wi-Fi, mobile data, and the actual location being on, had an impact on the GPS area of the EXIF data. The link below the experiment is a Q&A about EXIF data and BVI data. BVI stands for Binary Visual editor. Check out the Q&A for more information about metadata, EXIF data, and BVI.

The two links are the same exact spreadsheets but the only difference is that one is a psf and one will bring you to Micosoft Excel to view the file. The spreadsheet contains information about certain foods and drinks. This information includes calories, carbohydrates, fats and others. There are two columns to the right hand side of the page. These columns show the calculated calories, and the difference in calories. The calculated calories is based on the formula 4*(# of grams of proteins)+4*(# of grams of carbs)+9*(# of grams of fats). The difference in calories shows what the chart suggests the number of calories is subtracted from the number of calories calculated. There is a line graph at the bottom that compares the calories and calculated calories.

The link above is a pdf document explaining, in depth about this assignment. Inside this document there is a hyper link that you can click on there that will allow you to access the Microsoft Excel spreadsheet that holds the data I collected. There are 4 different sheets that all represent the same exact topic from different years. You can see the charts that were created by going to the bottom of the pdf page, or you can click on the link and look at the spreadsheet data and the chart together. On these Excel sheets, there are a couple formulas that were used and the use of the sort function is also used. There is also a key on each spreadsheet to show what each background color means.

The above link is a link to a Microsoft Access database called Orders. This file contains a four tables. The first table is a table of customers with the customers information. The second table is a table with customer oder information. The third table is a table full of items that are in the orders the customers have placed. The forth table is a table of products, this contains item information. The tables are linked together in relationships. Relationships work through the use of primary and foreign keys. Primary keys are values that are in most tables. They are unique to the table and there is no repeat information within this column. Most of the time the primary keys are numbers like a card ID or order number that noone else has. Foreign keys are what link tables together. A foreign key is a match of the primary key of another table. For example, in the CUSTOMER table the primary key is the CustomerID, and that links to the ORDER table by the ORDER table containing a column called CustomerID. THis is how the two tables are able to link and form a relationship. There are also two queries in the file. The both queries were written in SQL. The first query is a one table query involving the ITEM table. It takes out the price column and reorders the columns. It then takes out any order that has three or more quantities of that item. Then it sorts the table first by the ItemID, then the Quantity, then the OrderID. The second query is a two table query. This query involves the ITEM and PRODUCT tables. It includes the ProductID, the Quantity, and then a formula that becomes the Price column. The formula is [Quantity] * [PricePerItem]. This calulates the pric of the items based on the quantity of that item a customer wants to purchase.

• Many to Many Relationships = 5

The Many to Many query is between the Branch table and the Staff table. The Registration table is the junction table

• One to Many Relationships = 8

The One to Many query is between the Staff table and the PropertyForRent table.

• One to One Relationships = 1

The One to One query is between the Client table and the Registration table.

In this assignment, I created a database of my own interest. This database shows an Energy Management System that contains multiple tables and relationships between the tables which include: one-to-one, many-to-many, and one-to-many relationships. The database also contains three queries. The PDF file contains an Entity Relationship Diagram and sentences that describe the relations between the entities.