Homework no. 6

On a piece of paper, write MYSQL commands to do the following tasks:

1. Show current user.

2. Display all database.

3. Use a database called dbMybusiness.

4. Display all tables inside dbMybusiness.

5. Create a table called products with the following column name
                 prodID, prodName, prodSupplier, prodUnitPrice.  Decide the corresponding data type for each column name, Keys and constraints.

6. Display all records from table customers.

7. Display all records combining cusFirst and cusLast with column heading Fullname.

8. Delete a record with cusID  no 12.

9. Display all records from table customer that lives(cusAddress) in Los Angeles.

10. Discuss the difference between Primary key and Foreign key.

Homework5

On a piece of paper,
 Write the syntax of the following MySQL commands  &
 give at least one example of the command.

1. Create a User.
2. Grant privileges to a user.
3. CREATE- allows them to create new tables or databases
4.  DROP- allows them to them to delete tables or databases
5. DELETE- allows them to delete rows from tables 
6. INSERT- allows them to insert rows into tables
7. SELECT- allows them to use the Select command to read through databases
8. UPDATE- allow them to update table rows
9. What is the SQL command to view the current user
10. What does SQL stand for?

Homework 4

Create an autoexec.bat or autorun.inf that will automaticaly load a program once a USB drive is inserted into the computer.

On a piece of paper write code the of the file.

No home work today so enjoy your day.

Homework 3

I, Write the DOS commands of the following tasks.

        1. Hide file test.txt.



       2. Unhide the file test.txt


       3. Display all hidden files


       4. Copy all files with file extension .exe from the current drive to c:\Daniel

   
       5. Copy file test.txt to a new file test2.txt

      7. Erase all files that starts with A and followed by 5 characters and with file extension .com

      8. Change the prompt to Hello World :)

      9. Clear the the screen

     10. Display the date and accept the current date.


II.  Explain the function of the following DOS commands.

    1. tree

    2. CHKDSK

    3. Restore

    4. Format

    5. FDisk

III.
   
      What is batch file?


      What is autoexec.bat?

Homework 2

Due: 4/9/19 Time: 8:25 AM
Late homework will not be accepted.

 I. Write the DOS command for the following tasks.

      1. Display all files and directories of the current drive.
   
      2. Display all files and directories of the current drive that starts with letter W.
 
     3. Change the drive to the root directory c:\>
 
     4. Make a directory from the root drive and name it Daniel.

     5. Change the directory to Daniel

    6. Display all files on a wide screen format.

    7. Display all files with file extension exe.

    8. Delete the folder named Daniel.

    9. Display all the hidden files in System32 folder which is inside the folder Windows.

  10. Hide all files with file extension sys.

 II. In your own words describe the main uses of SQL. (5 pts.)

 III. Explain your thoughts or opinion on the issue of cybersecurity (5 pts.)