log 5th week (marron) v3

log (6/27/2016 - 7/1/2016)

======
monday
======

created stored procedures via transact-sql query
• addNewCar - adds a new car entry in the Cars table
• addNewCustomer - adds a new customer entry in the Customers table
• addNewSupplier - adds a new supplier entry in the Suppliers table
• deleteCarById - deletes a car entry in the Cars table with the id specified in the

parameter
• deleteCustomerById - deletes a customer entry in the Customers table based by the id

specified in the parameter
• deleteSupplierById - deletes a supplier entry in the Suppliers table based by the id

specified in the parameter
• displayAllCustomers - shows all customers in the Customers table
• displayAllSuppliers - shows all suppliers in the Suppliers table
• editCustomerDetailsById - selects a customer in the Customers table based by its id and

edits all the column values of that row entry
• editSupplierDetailsById - selects a supplier in the Suppliers table based by its id and

edits all the column valued of that row entry
• selectAllCars - shows all cars in the Cars table
• showAllCustomersAndSuppliers - shows a union table of the Customers and Suppliers table
• updateCarDetailsById - selects a car in the Cars table based by its id and edits all the

column values of that row entry
• updateCarPriceByBrandAndModel - selects a car in the Cars table based by its brand and

model and edits the price value of the car

renamed stored procedures
• placeOrder - renamed to placeOrderById
• placeOrder2 - renamed to placeOrder

altered stored procedures
• listAllOrders - adjusted SELECT clause; now uses inner joins instad of referencing

multiple tables
• placeOrder - added conditions that check whether parameter values are valid, in a sense

of the parameter values exist in each of their corresponding tables

created a trigger in the database via transact-sql query
• detectInvalidSecondHand - triggers upon execution of INSERT statement in the Cars table;

will trigger when the inserted value for the year of the car is less than 2014 and the

value for the condition is 'Second Hand'

updated Promotions page in the MCC website
• added new promotions in the website
• created new ActionResult in the Promotions controller for each of the new promotions
• created new views in the Promotions view for each of the new promotions

=======
tuesday
=======

created new trigger in the Cars table
• detectInvalidRegistrationDate - triggers upon execution of stored procedure placeOrder

wherein it checks if the value of the dateRegistered is less than the year of the model

release

updated rewards page of mcc website
• changed images of each of the rewards requested for update
• updated rewards icon on rewards page

encoded tokens in the metrobank card mobile survey of customer satisfactory survey - mcc

finance
• inserted 168 entries to the survey

=========
wednesday
=========

updated rewards and promotions page of mcc website
• changed images of each of the rewards requested for update
• fixed visual bugs found in the rewards page
• deleted an obsolete promo item in the rewards page

fill up systems and applications register
• added 120 new entries
• added data for columns users, architecture, hardware, and database
• verified contents of vendor column
• added columns application server, web application, and database
• added data for columns application server, web application, and database

========
thursday
========

1. indexing (clustered, non clustered)
2. SARGable (queries)
3. common functions (cast, convert, isnull) ex. SELECT * from .. . where age is NOT NULL
4. views
5. functions *
6. temporary tables (memory-based tables)
memory and physical
vs cursors
7. keys (primary/foreign)
8. normalization (insertion of foreign keys)
9. other query optimizations

updated promotions and home page of mcc website
• added new banner in home page
• edited featured promotions on home page
• updated pdf link for annual report
• added new promotions in model, view, and controller

======
friday
======

Troubleshoot M Cert web application where error shows duplicate entries in web.config file