BT0075, RDBMS with MySQL

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

Assignment

PROGRAM	BSc IT
SEMESTER	THIRD
SUBJECT CODE & NAME	BT0075, RDBMS with MySQL
BK ID	B1003
CREDIT &	4 CREDITS
MAX. MARKS	60

Q1 How to drop database, tables, and index in MySQL? Explainwith the help of examples.

Answer: MySQL ALTER command is very useful when you want to change a name of your table, any table field or if you want to add or delete an existing column in a table.

Let's begin with creation of a table called testalter_tbl.

Q.2 (a) Explain insert statement with example.

Answer: The INSERT statement lets you add one or more rows to a table or view in a SQL Server database. The statement is one of the primary data modification language (DML) statements available in Transact-SQL, along with UPDATE, MERGE, and DELETE. You can use the INSERT statement to add data that you specifically define, or you can add data that you retrieve from other tables or views. You can also include an OUTPUT clause in your INSERT statement to capture the statement’s results for auditing or verification purposes.

Performing a Basic Insert

(b) Exercise: Create table CUSTOMERS with fields – ID, name, age, address and salary and insert records in the table (insert at least five records.)

Answer: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database.

Syntax: There are two basic syntaxes of INSERT INTO statement as follows:

Q3 Explain update and replace statements with example.

Answer: In SQL, a view is a virtual table based on the result-set of an SQL statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

We cab add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

SQL CREATE VIEW Syntax:

Q4 Explain all the date and time functions in detail.

Answer: There is exclusive fields type to store Date and Date –Time in mysql or in other databases. As we know in any script date plays important role and we need to do many calculation and formatting to handle the date issues. It can be a simple Library book issue management to a customer compliant handling, these date fields are important for handling related data in a table.

MySQL have several date & time related functions to use in different situations and requirements. We will discuss some of the important functions here and use them for developing some sample codes.

·         date_add to add date & time to field data:We can use date_add function to calculate date & time values and store them in MySql

Q5. Describe the procedures to add new user account in MySQL.

Answer :  Create a new MySQL database user account

1. From the SiteWorx main menu, click Hosting Options > MySQL > Users.
   
   

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601