No homework.

Homework 7

Write on a piece of paper the MYSQL commands to execute the following tasks.

1. Create a new table containing these four columns: Emp#, Lastname, Firstname, and JobClass. The table name should be EMPLOYEES. The JobClass column should be able to store character strings up to a maximum length of four,  but the column values shouldn't be packed if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.

2. Add two columns to the EMPLOYEES table. One column , named EmpDate , contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees' date termination.

3. Modify the JobClass columnof the EMPLOYEES table so that it allows storing a maximum width of two characters.

4. Delete the EndDate column from the EMPLOYEES table.

5. Rename the EMPLOYEES table as JL_EMPS.

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.)

Mr. Madali is a absent Yay!

Tomorrow, I will be out for Robotics competition. The following are the provision for this class.

  A. Finish the exercises for different inputs.
  B. Independent work: Create a simple on-line quiz with a different type of questions., multiple choice, fill-in the blanks, true or false etc.

Good morning, :) today I want my students to start blogging their goal for the week in general. We will study the different types of Math methods and Date Methods. Solve problems using math methods.

Today's  Goal:
               Students should be able to complete solve problem using string methods and concepts.

Today, we will test if you guys were able to create a simple application on your own, writing an HTML code and javascript. Write a javascript code that output whether the given input is an odd or an even number.

Today, we will complete the code for converting peso to dollar and the other way around. You will learn how to apply function, operators and variable representation.

Today is a continuation of the activity we left from yesterday,
   1. Explore more ways to output data,
   2. Familiarize with the syntax and statements,
   3. Learn how to add comments and different variable representations.

Our Blog focus today is No 1 class. Don't to forget to comment and collaborate, but please observe proper decorum on-line :).

Goal for today

Good morning :)

    Yesterday, we discussed what javascript can do, who invented javascript, how to start a javascript and different ways to output or display data.

 Today in your blog, please discuss a little bit of what you have learned from yesterday. Tell something about what javascript can do. How to start a javascript and how to display data on screen.

Our plan to learn today are;
     
        1. Explore more ways to output data,
        2. Familiarize with the syntax and statements,
        3. Learn how to add comments and different variable representations.

Good morning,
     Today students are expected to complete 5 paragraph of About Me page. Apply necessary format like font color, size and other HTML tags.

Good morning class :)

       Yesterday we discussed basic HTML tags and functions, we learned how to start a webpage, change background color, set font size and color, add marquee effect and other formatting tags.

      Today we will continue by completing about me page and apply necessary html tags. and put it up to your blog. You will spend more of your time writing about yourself today. Good luck.

Objectives

Today our students will do the following;

              1. Review basic HTML tags
              2. Create a webpage using html
              3. Integrate to the blog
              4. Enhance the blog.
 
               .... and work happily :).

    My pic of the day.

   Quote of the day:

Smiling is definitely one of the best beauty remedies. If you have a good sense of humor and a good approach to life, that's beautiful.

Rashida Jones

Learning about blogging

Today my students will be learning how to create their own blog.

• Changing layout
• Adding pages
• refining the designs
• posting
• understand the importance of having a blog.

Welcome to First Period Class

Programming 1