تمرین های دیتابیس (DataBase)
Programming exercises دیتابیس (DataBase)Latest exercises دیتابیس (DataBase)
Parking Management Program Write: When arriving, arrival time and car license plate number stored when exit, exit time save for the desired car at any moment (in the parking lot, exit) and other information ...
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 ...
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 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 ...
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
Build a table with HTML to show the following information: Name, Score, Hassan Hassani 17.25 Affiliates Mohammed Mohammed Hassani 13 Accept Mohammad Rezaei 9 Receives 19 Mardami Milad Mohammadi 12 ...