Write MySQL code to create a table with the following field name: empNo, empName, empBasicSalary, empHouseAllowance, empPhoneNo

Write MySQL code to create a table with the following field name: empNo, empName, empBasicSalary, empHouseAllowance, empPhoneNo

---

CREATE TABLE Employees (
empNo INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
empName VARCHAR(30) NOT NULL,
empBasicSalary INT(50) NOT NULL,
empHouseAllowance INT(30) NOT NULL,
empPhoneNumber INT(10) NOT NULL
)

---

Future Great Thinker answered the question on August 7, 2020 at 08:40

Exams With Marking Schemes

• Grade 1
• Grade 2
• Grade 3
• Grade 4
• Grade 5
• Grade 6
• Grade 7
• Grade 8
• Grade 9
• PP1
• PP2
• Playgroup
• Form 1
• Form 2
• Form 3
• Form 4

Related Questions

---

• What is context switching? (Solved)
  

  What is context switching?

  Date posted: March 30, 2020 .    Answers (1)

• What are the characteristics of the following process schedulers. i. short term scheduler. ii. medium term scheduler. iii. long term scheduler (Solved)
  

  What are the characteristics of the following process schedulers. i. short term scheduler. ii. medium term scheduler. iii. long term scheduler

  Date posted: March 30, 2020 .    Answers (1)

• What are the characteristics of short term schedulers? (Solved)
  

  What are the characteristics of short term schedulers?

  Date posted: March 30, 2020 .    Answers (1)

• What are the characteristics of long term scheduler? (Solved)
  

  What are the characteristics of long term scheduler?

  Date posted: March 30, 2020 .    Answers (1)

• Distinguish between long and medium term scheduler (Solved)
  

  Distinguish between long and medium term scheduler

  Date posted: March 30, 2020 .    Answers (1)

• Differentiate between medium and short term schedulers (Solved)
  

  Differentiate between medium and short term schedulers.

  Date posted: March 30, 2020 .    Answers (1)

• Distinguish between the following process schedulers. (a) long term scheduler. (b) short term scheduler. (Solved)
  

  Distinguish between the following process schedulers. (a) long term scheduler. (b) short term scheduler.

  Date posted: March 30, 2020 .    Answers (1)

• Explain three common process schedulers (Solved)
  

  Explain three common process schedulers.

  Date posted: March 30, 2020 .    Answers (1)

• What is two-state process model? Give its description. (Solved)
  

  What is two-state process model, give it's description.

  Date posted: March 30, 2020 .    Answers (1)

• List and explain three major process scheduling queues (Solved)
  

  List and explain three major process scheduling queues

  Date posted: March 30, 2020 .    Answers (1)

• Briefly describe process control blocks (Solved)
  

  Briefly describe process control blocks

  Date posted: March 30, 2020 .    Answers (1)

• Briefly explain the four division of a process (Solved)
  

  When a program is loaded into the memory and it becomes a process, it can be divided into four sections - stack, heap, text and data.

  Date posted: March 30, 2020 .    Answers (1)

• What are the activities of operating systems related to real time system? (Solved)
  

  What are the activities of operating systems related to real time system?

  Date posted: March 24, 2020 .    Answers (1)

• Highlight activities of operating sytems with regard to interactivity (Solved)
  

  Interactivity refers to the ability of users to interact with a computer system. An Operating system does the following activities related to interactivity -
  
  Provides the user an interface to interact with the system.
  Manages input devices to take inputs from the user. For example, keyboard.
  Manages output devices to show outputs to the user. For example, Monitor.

  Date posted: March 24, 2020 .    Answers (1)

• Highlight two advantages and two disadvantages of multiprogramming (Solved)
  

  Advantages
  High and efficient CPU utilization.
  User feels that many programs are allotted CPU almost simultaneously.
  
  Disadvantages
  CPU scheduling is required.
  To accommodate many jobs in memory, memory management is required.

  Date posted: March 24, 2020 .    Answers (1)

• Basing on multitasking operating systems highlight six major activities of operating system involved (Solved)
  

  Basing on multitasking operating systems highlight six major activities of operating system involved.

  Date posted: March 23, 2020 .    Answers (1)

• What are the activities of operating systems with relation to batch processing? (Solved)
  

  What are the activities of operating systems with relation to batch processing?

  Date posted: March 23, 2020 .    Answers (1)

• What are the advantages of distributed operating systems? (Solved)
  

  The advantages of distributed systems are as follows -
  
  With resource sharing facility, a user at one site may be able to use the resources available at another.
  Speedup the exchange of data with one another via electronic mail.
  If one site fails in a distributed system, the remaining sites can potentially continue operating.
  Better service to the customers.
  Reduction of the load on the host computer.
  Reduction of delays in data processing.

  Date posted: March 21, 2020 .    Answers (1)

• Briefly describe distributed operating systems. (Solved)
  

  Distributed systems use multiple central processors to serve multiple real-time applications and multiple users. Data processing jobs are distributed among the processors accordingly.
  
  The processors communicate with one another through various communication lines (such as high-speed buses or telephone lines). These are referred as loosely coupled systems or distributed systems. Processors in a distributed system may vary in size and function. These processors are referred as sites, nodes, computers, and so on.
  
  The advantages of distributed systems are as follows -
  
  With resource sharing facility, a user at one site may be able to use the resources available at another.
  Speedup the exchange of data with one another via electronic mail.
  If one site fails in a distributed system, the remaining sites can potentially continue operating.
  Better service to the customers.
  Reduction of the load on the host computer.
  Reduction of delays in data processing.

  Date posted: March 21, 2020 .    Answers (1)

• Highlight three disadvantages of time sharing operating systems (Solved)
  

  Time-sharing is a technique which enables many people, located at various terminals, to use a particular computer system at the same time. Time-sharing or multitasking is a logical extension of multiprogramming. Processor's time which is shared among multiple users simultaneously is termed as time-sharing.
  
  The main difference between Multiprogrammed Batch Systems and Time-Sharing Systems is that in case of Multiprogrammed batch systems, the objective is to maximize processor use, whereas in Time-Sharing Systems, the objective is to minimize response time.
  
  Disadvantages of Time-sharing operating systems are as follows -
  
  Problem of reliability.
  Question of security and integrity of user programs and data.
  Problem of data communication.

  Date posted: March 21, 2020 .    Answers (1)