# Activity 20: Data Structure Again

## **1\. Product Table**

| **ID** | **Name** | **Category** | **Price** | **Stock** | **Supplier Email** |  |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Laptop | Electronics | 750 | 50 | [**supplier1@gmail.com**](mailto:supplier1@gmail.com) |  |
| 2 | Desk Chair | Furniture | 100 | 200 | [**supplier2@gmail.com**](mailto:supplier2@gmail.com) |  |
| 3 | Smartwatch | Electronics | 200 | 150 | [**supplier3@gmail.com**](mailto:supplier3@gmail.com) |  |
| 4 | Notebook | Stationery | 5 | 500 | [**supplier4@gmail.com**](mailto:supplier4@gmail.com) |  |
| 5 | Running Shoes | Apparel | 80 | 100 | [**supplier5@gmail.com**](mailto:supplier5@gmail.com) |  |

### Product Lists

**Copy**

**Copy**

```plaintext
product_id_list = [1,2,3,4,5]
product_name_list = ["Laptop","Desk Chair","Smartwatch","Notebook","Running Shoes"]
product_category_list = ["Electronics","Furniture","Electronics","Stationery","Apparel"]
product_price_list = [750,100,200,5,80]
product_stock_list = [50,200,150,500,100]
product_supplier_email_list = ["supplier1@gmail.com","supplier2@gmail.com","supplier3@gmail.com","supplier4@gmail.com","supplier5@gmail.com"]
```

### Product Objects

**Copy**

**Copy**

```plaintext
product_object1 = {
    "id" : 1,
    "name" : "Laptop",
    "category" : "Electronics",
    "price" : 750,
    "stock" : 50,
    "supplier_email" : "supplier1@gmail.com"
}

product_object2 = {
    "id" : 2,
    "name" : "Desk Chair",
    "category" : "Furniture",
    "price" : 100,
    "stock" : 200,
    "supplier_email" : "supplier2@gmail.com"
}

product_object3 = {
    "id" : 3,
    "name" : "Smartwatch",
    "category" : "Electronics",
    "price" : 200,
    "stock" : 150,
    "supplier_email" : "supplier3@gmail.com"
}

product_object4 = {
    "id" : 4,
    "name" : "Notebook",
    "category" : "Stationery",
    "price" : 5,
    "stock" : 500,
    "supplier_email" : "supplier4@gmail.com"
}

product_object5 = {
    "id" : 5,
    "name" : "Running Shoes",
    "category" : "Apparel",
    "price" : 80,
    "stock" : 100,
    "supplier_email" : "supplier5@gmail.com"
}
```

### Product List of Objects

**Copy**

**Copy**

```plaintext
products = [
    {
        "id" : 1,
        "name" : "Laptop",
        "category" : "Electronics",
        "price" : 750,
        "stock" : 50,
        "supplier_email" : "supplier1@gmail.com"
    },
    {
        "id" : 2,
        "name" : "Desk Chair",
        "category" : "Furniture",
        "price" : 100,
        "stock" : 200,
        "supplier_email" : "supplier2@gmail.com"
    },
    {
        "id" : 3,
        "name" : "Smartwatch",
        "category" : "Electronics",
        "price" : 200,
        "stock" : 150,
        "supplier_email" : "supplier3@gmail.com"
    },
    {
        "id" : 4,
        "name" : "Notebook",
        "category" : "Stationery",
        "price" : 5,
        "stock" : 500,
        "supplier_email" : "supplier4@gmail.com"
    },
    {
        "id" : 5,
        "name" : "Running Shoes",
        "category" : "Apparel",
        "price" : 80,
        "stock" : 100,
        "supplier_email" : "supplier5@gmail.com"
    }
]
```

## **2\. Employee Table**

| **ID** | **Name** | **Department** | **Age** | **Email** |  |
| --- | --- | --- | --- | --- | --- |
| 1 | John Doe | Sales | 30 | [**john.doe@company.com**](mailto:john.doe@company.com) |  |
| 2 | Jane Smith | Human Resources | 25 | [**jane.smith@company.com**](mailto:jane.smith@company.com) |  |
| 3 | Mark Johnson | IT | 40 | [**mark.johnson@company.com**](mailto:mark.johnson@company.com) |  |
| 4 | Lisa Wong | Marketing | 28 | [**lisa.wong@company.com**](mailto:lisa.wong@company.com) |  |
| 5 | Paul McDonald | Finance | 35 | [**paul.mcdonald@company.com**](mailto:paul.mcdonald@company.com) |  |

### Employee Lists

**Copy**

**Copy**

```plaintext
employee_id_list = [1,2,3,4,5]
employee_name_list = ["John Doe","Jane Smith","Mark Johnson","Lisa Wong","Paul McDonald"]
employee_department_list = ["Sales","Human Resources","IT","Marketing","Finance"]
employee_age_list = [30,25,40,28,35]
employee_email_list = ["john.doe@company.com","jane.smith@company.com","mark.johnson@company.com","lisa.wong@company.com","paul.mcdonald@company.com"]
```

### Employee Objects

**Copy**

**Copy**

```plaintext
employee_object1 = {
    "id" : 1,
    "name" : "John Doe",
    "department" : "Sales",
    "age" : 30,
    "email" : "john.doe@company.com"
}

employee_object2 = {
    "id" : 2,
    "name" : "Jane Smith",
    "department" : "Human Resources",
    "age" : 25,
    "email" : "jane.smith@company.com"
}

employee_object3 = {
    "id" : 3,
    "name" : "Mark Johnson",
    "department" : "IT",
    "age" : 40,
    "email" : "mark.johnson@company.com"
}

employee_object4 = {
    "id" : 4,
    "name" : "Lisa Wong",
    "department" : "Marketing",
    "age" : 28,
    "email" : "lisa.wong@company.com"
}

employee_object5 = {
    "id" : 5,
    "name" : "Paul McDonald",
    "department" : "Finance",
    "age" : 35,
    "email" : "paul.mcdonald@company.com"
}
```

### Employee List of Objects

**Copy**

**Copy**

```plaintext
employees = [
    {
        "id" : 1,
        "name" : "John Doe",
        "department" : "Sales",
        "age" : 30,
        "email" : "john.doe@company.com"
    },
    {
        "id" : 2,
        "name" : "Jane Smith",
        "department" : "Human Resources",
        "age" : 25,
        "email" : "jane.smith@company.com"
    },
    {
        "id" : 3,
        "name" : "Mark Johnson",
        "department" : "IT",
        "age" : 40,
        "email" : "mark.johnson@company.com"
    },
    {
        "id" : 4,
        "name" : "Lisa Wong",
        "department" : "Marketing",
        "age" : 28,
        "email" : "lisa.wong@company.com"
    },
    {
        "id" : 5,
        "name" : "Paul McDonald",
        "department" : "Finance",
        "age" : 35,
        "email" : "paul.mcdonald@company.com"
    }
]
```

## **3\. Books Table**

| **ID** | **Title** | **Author** | **Genre** | **Published Year** | **ISBN** | **Stock** | **Price** |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | The Great Gatsby | F. Scott Fitzgerald | Fiction | 1925 | 978-0743273565 | 20 | 15.99 |
| 2 | To Kill a Mockingbird | Harper Lee | Fiction | 1960 | 978-0060935467 | 35 | 10.99 |
| 3 | 1984 | George Orwell | Dystopian | 1949 | 978-0451524935 | 40 | 9.99 |
| 4 | The Catcher in the Rye | J.D. Salinger | Fiction | 1951 | 978-0316769488 | 25 | 8.99 |
| 5 | A Brief History of Time | Stephen Hawking | Non-fiction | 1988 | 978-0553380163 | 10 | 18.99 |

### Book Lists

**Copy**

**Copy**

```plaintext
book_id_list = [1,2,3,4,5]
book_title_list = ["The Great Gatsby","To Kill a Mockingbird","1984","The Catcher in the Rye","A Brief History of Time"]
book_author_list = ["F. Scott Fitzgerald","Harper Lee","George Orwell","J.D. Salinger","Stephen Hawking"]
book_genre_list = ["Fiction","Fiction","Dystopian","Fiction","Non-fiction"]
book_published_year_list = [1925,1960,1949,1951,1988]
book_isbn_list = ["978-0743273565","978-0060935467","978-0451524935","978-0316769488","978-0553380163"]
book_stock_list = [20,35,40,25,10]
book_price_list = [15.99,10.99,9.99,8.99,18.99]
```

### Book Objects

**Copy**

**Copy**

```plaintext
book_object1 = {
    "id" : 1,
    "title" : "The Great Gatsby",
    "author" : "F. Scott Fitzgerald",
    "genre" : "Fiction",
    "published_year" : 1925,
    "isbn" : "978-0743273565",
    "stock" : 20,
    "price" : 15.99
}

book_object2 = {
    "id" : 2,
    "title" : "To Kill a Mockingbird",
    "author" : "Harper Lee",
    "genre" : "Fiction",
    "published_year" : 1960,
    "isbn" : "978-0060935467",
    "stock" : 35,
    "price" : 10.99
}

book_object3 = {
    "id" : 3,
    "title" : "1984",
    "author" : "George Orwell",
    "genre" : "Dystopian",
    "published_year" : 1949,
    "isbn" : "978-0451524935",
    "stock" : 40,
    "price" : 9.99
}

book_object4 = {
    "id" : 4,
    "title" : "The Catcher in the Rye",
    "author" : "J.D. Salinger",
    "genre" : "Fiction",
    "published_year" : 1951,
    "isbn" : "978-0316769488",
    "stock" : 25,
    "price" : 8.99
}

book_object5 = {
    "id" : 5,
    "title" : "A Brief History of Time",
    "author" : "Stephen Hawking",
    "genre" : "Non-fiction",
    "published_year" : 1988,
    "isbn" : "978-0553380163",
    "stock" : 10,
    "price" : 18.99
}
```

### Book List of Objects

**Copy**

**Copy**

```plaintext
books = [
    {
        "id" : 1,
        "title" : "The Great Gatsby",
        "author" : "F. Scott Fitzgerald",
        "genre" : "Fiction",
        "published_year" : 1925,
        "isbn" : "978-0743273565",
        "stock" : 20,
        "price" : 15.99
    },
    {
        "id" : 2,
        "title" : "To Kill a Mockingbird",
        "author" : "Harper Lee",
        "genre" : "Fiction",
        "published_year" : 1960,
        "isbn" : "978-0060935467",
        "stock" : 35,
        "price" : 10.99
    },
    {
        "id" : 3,
        "title" : "1984",
        "author" : "George Orwell",
        "genre" : "Dystopian",
        "published_year" : 1949,
        "isbn" : "978-0451524935",
        "stock" : 40,
        "price" : 9.99
    },
    {
        "id" : 4,
        "title" : "The Catcher in the Rye",
        "author" : "J.D. Salinger",
        "genre" : "Fiction",
        "published_year" : 1951,
        "isbn" : "978-0316769488",
        "stock" : 25,
        "price" : 8.99
    },
    {
        "id" : 5,
        "title" : "A Brief History of Time",
        "author" : "Stephen Hawking",
        "genre" : "Non-fiction",
        "published_year" : 1988,
        "isbn" : "978-0553380163",
        "stock" : 10,
        "price" : 18.99
    }
]
```

## **4\. University Table**

| **ID** | **Name** | **Location** | **Established Year** | **Type** | **Website** |
| --- | --- | --- | --- | --- | --- |
| 1 | University of the Philippines | Quezon City | 1908 | Public | [**up.edu.ph**](http://www.up.edu.ph/) |
| 2 | Ateneo de Manila University | Quezon City | 1859 | Private | [**ateneo.edu**](http://www.ateneo.edu/) |
| 3 | De La Salle University | Manila | 1911 | Private | [**dlsu.edu.ph**](http://www.dlsu.edu.ph/) |
| 4 | University of Santo Tomas | Manila | 1611 | Private | [**ust.edu.ph**](http://www.ust.edu.ph/) |
| 5 | Polytechnic University of the Philippines | Manila | 1904 | Public | [**pup.edu.ph**](http://www.pup.edu.ph/) |

### University Lists

**Copy**

**Copy**

```plaintext
university_id_list = [1,2,3,4,5]
university_name_list = ["University of the Philippines","Ateneo de Manila University","De La Salle University","University of Santo Tomas","Polytechnic University of the Philippines"]
university_location_list = ["Quezon City","Quezon City","Manila","Manila","Manila"]
university_established_year_list = [1908,1859,1911,1611,1904]
university_type_list = ["Public","Private","Private","Private","Public"]
university_website_list = ["www.up.edu.ph","www.ateneo.edu","www.dlsu.edu.ph","www.ust.edu.ph","www.pup.edu.ph"]
```

### University Objects

**Copy**

**Copy**

```plaintext
university_object1 = {
    "id" : 1,
    "name" : "University of the Philippines",
    "location" : "Quezon City",
    "established_year" : 1908,
    "type" : "Public",
    "website" : "www.up.edu.ph"
}

university_object2 = {
    "id" : 2,
    "name" : "Ateneo de Manila University",
    "location" : "Quezon City",
    "established_year" : 1859,
    "type" : "Private",
    "website" : "www.ateneo.edu"
}

university_object3 = {
    "id" : 3,
    "name" : "De La Salle University",
    "location" : "Manila",
    "established_year" : 1911,
    "type" : "Private",
    "website" : "www.dlsu.edu.ph"
}

university_object4 = {
    "id" : 4,
    "name" : "University of Santo Tomas",
    "location" : "Manila",
    "established_year" : 1611,
    "type" : "Private",
    "website" : "www.ust.edu.ph"
}

university_object5 = {
    "id" : 5,
    "name" : "Polytechnic University of the Philippines",
    "location" : "Manila",
    "established_year" : 1904,
    "type" : "Public",
    "website" : "www.pup.edu.ph"
}
```

### University List of Objects

**Copy**

**Copy**

```plaintext
universities = [
    {
        "id" : 1,
        "name" : "University of the Philippines",
        "location" : "Quezon City",
        "established_year" : 1908,
        "type" : "Public",
        "website" : "www.up.edu.ph"
    },
    {
        "id" : 2,
        "name" : "Ateneo de Manila University",
        "location" : "Quezon City",
        "established_year" : 1859,
        "type" : "Private",
        "website" : "www.ateneo.edu"
    },
    {
        "id" : 3,
        "name" : "De La Salle University",
        "location" : "Manila",
        "established_year" : 1911,
        "type" : "Private",
        "website" : "www.dlsu.edu.ph"
    },
    {
        "id" : 4,
        "name" : "University of Santo Tomas",
        "location" : "Manila",
        "established_year" : 1611,
        "type" : "Private",
        "website" : "www.ust.edu.ph"
    },
    {
         "id" : 5,
        "name" : "Polytechnic University of the Philippines",
        "location" : "Manila",
        "established_year" : 1904,
        "type" : "Public",
        "website" : "www.pup.edu.ph"
    }      
]
```

## **5\. Restaurant Table**

| **ID** | **Name** | **Location** | **Cuisine Type** | **Established Year** | **Website or Contact** |
| --- | --- | --- | --- | --- | --- |
| 1 | Vikings Luxury Buffet | Pasay City | Buffet | 2011 | [**vikings.ph**](http://www.vikings.ph/) |
| 2 | Antonio's Restaurant | Tagaytay | Fine Dining | 2002 | [**antoniosrestaurant.ph**](http://www.antoniosrestaurant.ph/) |
| 3 | Mesa Filipino Moderne | Makati City | Filipino | 2009 | [**mesa.ph**](http://www.mesa.ph/) |
| 4 | Manam Comfort Filipino | Quezon City | Filipino | 2013 | [**manam.ph**](http://www.manam.ph/) |
| 5 | Ramen Nagi | Various Locations | Japanese | 2013 | [**ramennagi.com.ph**](http://www.ramennagi.com.ph/) |

### Restaurant Lists

**Copy**

**Copy**

```plaintext
restaurant_id_list = [1,2,3,4,5]
restaurant_name_list = ["Vikings Luxury Buffet","Antonio's Restaurant","Mesa Filipino Moderne","Manam Comfort Filipino","Ramen Nagi"]
restaurant_location_list = ["Pasay City","Tagaytay","Makati City","Quezon City","Various Locations"]
restaurant_cuisine_type_list = ["Buffet","Fine Dining","Filipino","Filipino","Japanese"]
restaurant_established_year_list = [2011,2002,2009,2013,2013]
restaurant_website_or_contact_list = ["www.vikings.ph","www.antoniosrestaurant.ph","www.mesa.ph","www.manam.ph","www.ramennagi.com.ph"]
```

### Restaurant Objects

**Copy**

**Copy**

```plaintext
restaurant_object1 = {
    "id" : 1,
    "name" : "Vikings Luxury Buffet",
    "location" : "Pasay City",
    "cuisine_type" : "Buffet",
    "established_year" : 2011,
    "website_or_contact" : "www.vikings.ph"
}

restaurant_object2 = {
    "id" : 2,
    "name" : "Antonio's Restaurant",
    "location" : "Tagaytay",
    "cuisine_type" : "Fine Dining",
    "established_year" : 2002,
    "website_or_contact" : "www.antoniosrestaurant.ph"
}

restaurant_object3 = {
    "id" : 3,
    "name" : "Mesa Filipino Moderne",
    "location" : "Makati City",
    "cuisine_type" : "Filipino",
    "established_year" : 2009,
    "website_or_contact" : "www.mesa.ph"
}

restaurant_object4 = {
    "id" : 4,
    "name" : "Manam Comfort Filipino",
    "location" : "Quezon City",
    "cuisine_type" : "Filipino",
    "established_year" : 2013,
    "website_or_contact" : "www.manam.ph"
}

restaurant_object5 = {
    "id" : 5,
    "name" : "Ramen Nagi",
    "location" : "Various Locations",
    "cuisine_type" : "Japanese",
    "established_year" : 2013,
    "website_or_contact" : "www.ramennagi.com.ph"
}
```

### Restaurant List of Objects

**Copy**

**Copy**

```plaintext
restaurants = [
    {
        "id" : 1,
        "name" : "Vikings Luxury Buffet",
        "location" : "Pasay City",
        "cuisine_type" : "Buffet",
        "established_year" : 2011,
        "website_or_contact" : "www.vikings.ph"
    },
    {
        "id" : 2,
        "name" : "Antonio's Restaurant",
        "location" : "Tagaytay",
        "cuisine_type" : "Fine Dining",
        "established_year" : 2002,
        "website_or_contact" : "www.antoniosrestaurant.ph"
    },
    {
        "id" : 3,
        "name" : "Mesa Filipino Moderne",
        "location" : "Makati City",
        "cuisine_type" : "Filipino",
        "established_year" : 2009,
        "website_or_contact" : "www.mesa.ph"
    },
    {
        "id" : 4,
        "name" : "Manam Comfort Filipino",
        "location" : "Quezon City",
        "cuisine_type" : "Filipino",
        "established_year" : 2013,
        "website_or_contact" : "www.manam.ph"
    },
    {
        "id" : 5,
        "name" : "Ramen Nagi",
        "location" : "Various Locations",
        "cuisine_type" : "Japanese",
        "established_year" : 2013,
        "website_or_contact" : "www.ramennagi.com.ph"
    }
]
```