Databases | SQL | Oracle | MS Access Answers

atm management system code in sql

 How to reflect the real-time update of the information of the management system module?

1.     How is the interactive operation of the library's online management system, especially the information update module operated by borrowing back?

atm managment system in sql

1. Consider a case of NEWSPAPER HAWKER in your society and design ERD with Physical data Model. Also, design a complete database using ERD.
2.  
3. NOTE: Consider different newspapers on the basis of language, frequency, pages, regional / nationwide, etc.

Write SQL code that create a report that ask the user to enter publisher’s name in any case and in any form (entering full name or part there of) and it must retrieve all the books details published by this specific publisher. It must display isbn, title, author name, date published, total copies, total price.

Important Facts:     

✓ Page width must be 132 and page length 19

✓ The code must not display the number of records retrieved and it must not verify the value entered. ✓ Reset all the format that you created

✓ Use local currency for prices

✓ Negative marking will apply if columns aliases are used within the query statement. 

Write SQL code that creates or update a view named same_orders_vw, which will also create columns before it extract data from the database. The view must store details of customers who have ordered the same books as the one in order number 1007. The data to be stored in the view must contain customer no, customer names, book title, address and city as single and quantity. Sort the output in ascending order of customer no. 

Mysql database connectivity through Java program

insert data using Java program fields are given below for insert

student name, student father name, student mother name, student roll number, student address

Consider an online video-sharing platform like YouTube which hosts tens of thousands of channels and crores of users.

Database

The sample database consists of tables that store the information of users, channels, videos, genres and likes/dislikes.

Note:

channel_user table

channel_iduser_idsubscribed_datetime10012020-12-10 10:30:4510072020-10-10 11:30:45.........

channel_usertable stores the data of the channel_ids and their subscribers' user_ids.First row in the table represents that the user with user_id = 1 is subscribed to the channel with channel_id = 100 at

2020-12-10 10:30:45user_likes table

user_idvideo_idreaction_typereacted_at110LIKE2020-12-10 10:30:45710DISLIKE2020-10-10 11:30:45............

Similarly,

user_likestable stores the data of video_id and the user_ids who reacted to the video.video_genre table

video_idgenre_id1020110202......

Similarly,

I CAN EXPLAIN QUESTION CLEARLY....

Question 1 

Write SQL command to create the SALARY table having the following columns and their constraints. You are required to choose the appropriate data type for each column by your own.

Column Name  Data Type Data Type

Month  - -

Basic-salary  - NOT NULL

House-allow  - NOT NULL

Medical-allow  - NOT NULL

Total-salary  - DEFAULT 500

Income-tax  - UNIQUE

Net-salary  - NOT NULL

EmpID  - -

Question 2 

Write the following SQL commands for the SALARAY table created in question 1.

⦁ Add the primary key constraint on Month & EmpID columns using ALTER command.

⦁ Add the foreign key constraint on EmpID column using ALTER command.

Note: EmpID is a primary key column in Employee table.