Author Archives: cyruslab

[python]Disabling and enabling Windows proxy settings

References: https://superuser.com/questions/1113796/how-to-run-a-python-script-with-cmd-exe-and-make-it-invisible/1113801 https://stackoverflow.com/questions/31348111/setting-proxy-settings-in-windows-with-python-using-internetsetoption Requirements Disable and enable the proxy without closing internet explorer. Enable the proxy setting when auto configuration url (PAC location) is not available. Trigger the script to disable proxy when your laptop is connected out of office. … Continue reading

Posted in Python, Scripting, Windows | Tagged , , , , , | Leave a comment

[DATABASE]Auto incremental on primary key

I created a relation ENTRY_TEST, the primary key is entryid which will be auto incremented, when inserting data I do not need to assign ID. I will insert a few values: Let’s check the relation:

Posted in General stuffs | Tagged , | Leave a comment

[database]Functions provided by DBMS

Here is a list of non-exhaustive functions provided by DBMS (Database management system) To prevent data lost during system failure, it should provide reliable recovery service. Provide transaction service for user such as read (select), update, delete, commit, insert, rollback. … Continue reading

Posted in Database | Tagged | Leave a comment

[DATABASE] File base vs database

This post illustrates the need for database approach to manage data. Problems with file base approach Data is stored in file defined by application, hence there is a possibility of potential useful data needed by another application but not aware … Continue reading

Posted in Database | Tagged | Leave a comment

[DATABASE]ACID property of DBMS

Atomicity refers to a transaction is either fully completed or not completed at all, there is no partial complete transaction. This also refers to all or none rule. Consistency refers during transaction the integrity constraints are maintained so that the … Continue reading

Posted in Database | Tagged , | Leave a comment

[DATABASE] VIEWS

Views are virtual tables derived from columns and rows from the base table. Views provide what data are needed by the users, saving the trouble for users to understand the complexity and abstraction of the base tables. Views are dynamic, … Continue reading

Posted in Database | Tagged | Leave a comment

[DATABASE]SQL query examples

There are three relations used for this example – RENTAL_CUSTOMER, CAR, RENTAL. Below are the SQL statements used to create the relations. Data have been inserted to the relations: RENTAL_CUSTOMER CAR RENTAL List all cars rented by Smith since 1st … Continue reading

Posted in Database | Tagged | Leave a comment