Activity 20: Data Structure Again

1. Product Table

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

Product Lists

Copy

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

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

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
2	Jane Smith	Human Resources	25	jane.smith@company.com
3	Mark Johnson	IT	40	mark.johnson@company.com
4	Lisa Wong	Marketing	28	lisa.wong@company.com
5	Paul McDonald	Finance	35	paul.mcdonald@company.com

Employee Lists

Copy

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

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

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

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

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

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

Copy

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

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

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

Copy

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

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

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"
    }
]

Activity 20: Data Structure Again

1. Product Table

Product Lists

Product Objects

Product List of Objects

2. Employee Table

Employee Lists

Employee Objects

Employee List of Objects

3. Books Table

Book Lists

Book Objects

Book List of Objects

4. University Table

University Lists

University Objects

University List of Objects

5. Restaurant Table

Restaurant Lists

Restaurant Objects

Restaurant List of Objects

Comments

More from this blog

Activity 48: Documentation of Python SMTP

Activity 46: Documentation of Python JWT

Activity 44: Documentation of Python Flask Encryption and Decryption

Activity 42: Documentation of Python Flask hash

Activity 41: Python Flask Hash

Command Palette

1. Product Table

Product Lists

Product Objects

Product List of Objects

2. Employee Table

Employee Lists

Employee Objects

Employee List of Objects

3. Books Table

Book Lists

Book Objects

Book List of Objects

4. University Table

University Lists

University Objects

University List of Objects

5. Restaurant Table

Restaurant Lists

Restaurant Objects

Restaurant List of Objects

Comments

More from this blog