# Activity 17: 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 | ## **List**: * ```typescript Laptop, Desk Chair, Smartwatch, Notebook, Running Shoes ``` ## **Object**: ```typescript ID: 1, Name: Laptop, Category: Electronics, Price: 750, Stock: 50, Supplier Email: supplier1@gmail.com" ``` ## **List of Objects**: * ```typescript [ { 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 | * **List**: * ```typescript ["John Doe", "Jane Smith", "Mark Johnson", "Lisa Wong", "Paul McDonald"] ``` * **Object**: * ```typescript { "ID": 1, "Name": "John Doe", "Department": "Sales", "Age": 30, "Email": "john.doe@company.com" } ``` * **List of Objects**: * ```typescript [ { "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 | * **List**: * ```typescript "The Great Gatsby", "To Kill a Mockingbird", "1984", "The Catcher in the Rye", "A Brief History of Time", ``` * **Object**: * ```typescript { "ID": 1, "Title": "The Great Gatsby", "Author": "F. Scott Fitzgerald", "Genre": "Fiction", "Published Year": 1925, "ISBN": "978-0743273565", "Stock": 20, "Price": 15.99 } ``` * **List of Objects**: * ```typescript [ { "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 | [www.up.edu.ph](http://www.up.edu.ph) | | 2 | Ateneo de Manila University | Quezon City | 1859 | Private | [www.ateneo.edu](http://www.ateneo.edu) | | 3 | De La Salle University | Manila | 1911 | Private | [www.dlsu.edu.ph](http://www.dlsu.edu.ph) | | 4 | University of Santo Tomas | Manila | 1611 | Private | [www.ust.edu.ph](http://www.ust.edu.ph) | | 5 | Polytechnic University of the Philippines | Manila | 1904 | Public | [www.pup.edu.ph](http://www.pup.edu.ph) | * **List**: * ```typescript "University of the Philippines", "Ateneo de Manila University", "De La Salle University", "University of Santo Tomas", "Polytechnic University of the Philippines" ``` * **Object**: * ```typescript { "ID": 1, "Name": "University of the Philippines", "Location": "Quezon City", "Established Year": 1908, "Type": "Public", "Website": "www.up.edu.ph" } ``` * **List of Objects**: * ```typescript [ { "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" } ] ```