Search
Kobla Amevor’s Tech Systems Company at Battor offers a large selection of computers, keyboards, servers,
scanners, networking equipment, peripherals and security systems. The prices of computers and networking
equipment are constantly changing.
When a customer requests for information about the prices of products, a sales agent refers to a book
containing the price list and then calls the supplier for the current price to check if there’s been a price
increment.
The supplier also utilizes a manual catalogue sheet, which has to be refreshed every day. Frequently, Kobla
Amevor’s sales agent spend some time waiting for the supplier to confirm prices as they usually do not
have the most current pricing promptly available.
What are the implications of the current business processes on the efficiency and profitability of Kobla
Amevor’s Tech Systems Company? Explain ways in which the business can be improved through the use
of information systems.
Identify and with practical examples give the different types of languages that are
available in the DBMS?
How is the pattern matching done in the SQL?
1) a. Explain the concept of ACID properties in DBMS in your own words?
b. How is the pattern matching done in the SQL?
2) Identify and with practical examples give the different types of languages that are
available in the DBMS?
Identify and with practical examples give the different types of languages that are available in the DBMS?
How is the pattern matching done in the SQL?
Explain the concept of ACID properties in DBMS in your own words?
Patient # =1111
Surgeon# = 311
Surgery Date = 12.Jun.95
Patient Name = John White
Patient Address = 15 New St., New York, NY
Surgeon Name = Michael Diamond
Surgery = Kidney stones removal
Drug admin = None
Side effects = Rash
- What normal form is the relation in ?
- If it is not in 3NF convert into 3NF.Explain your answer.
Create a table Department(DEPT_ID, DEPT_NAME, MGR_ID, LOC_ID)
For each of the above attributes, define their corresponding data types as per your understanding.
Write an SQL query to Insert 6 tuples to each table
Write an SQL query to fetch the departments that have less than one person in it.
Write an SQL query to fetch employee names with salaries >= 40000 and <= 100000.
Write an SQL query to print details of the Employee whose FIRST NAME ends with ‘n’ and contains six alphabets.
Write an SQL query to print details for department excluding department name as “HR” and “IT” from department table.
Write an SQL query to Add a new column to the table employee with the column name as Email_id.
Write an SQL query to rename the table employee to employees and department to departments.
Write an SQL query to List out the maximum salary of the employee.
#340153 on Dec 2023