The goal of this activity is to help you understand the key differences between three important data structures: List, Object, and List of Objects. This activity requires no coding; it is purely focused on comprehension of these concepts.
1. Product Table
Product Lists
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
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
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
Employee Lists
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
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
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
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
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
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 |
| 2 | Ateneo de Manila University | Quezon City | 1859 | Private | ateneo.edu |
| 3 | De La Salle University | Manila | 1911 | Private | dlsu.edu.ph |
| 4 | University of Santo Tomas | Manila | 1611 | Private | ust.edu.ph |
| 5 | Polytechnic University of the Philippines | Manila | 1904 | Public | pup.edu.ph |
University Lists
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
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
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 |
| 2 | Antonio's Restaurant | Tagaytay | Fine Dining | 2002 | antoniosrestaurant.ph |
| 3 | Mesa Filipino Moderne | Makati City | Filipino | 2009 | mesa.ph |
| 4 | Manam Comfort Filipino | Quezon City | Filipino | 2013 | manam.ph |
| 5 | Ramen Nagi | Various Locations | Japanese | 2013 | ramennagi.com.ph |
Restaurant Lists
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
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
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"
}
]
