تمرین های دیتابیس (DataBase)
Programming exercises دیتابیس (DataBase)Latest exercises دیتابیس (DataBase)
Write a program to create a trigger to reduce the capacity of the class in the classroom table if the new record is added to the Student table. The Student table has the following fields: • Student code ...
Design the database of a restaurant and write a query about making tables and keys. Tips: In this restaurant we want to have a list of foods, orders and customers in the system
Suppose we have the following 2 tables Users-> name, idbooks-> User_id, id, name 1- Write a query that shows user-related books at No. 2- Write a query to user names a ...
Design a database for a mobile store that includes two Customers and Orders (orders) tables. Customer table should include: The full name of the Dean Birthday Mobile Note and the Order Table should be ...
Suppose the database of a language school consists of the following tables: Students -> id, name, phone, ageteacherrs -> id, name, phone, age1- Write a high table construction 2- Write a query that creates a class called ...