Tools

Title
Image Resizer Image Resizer Text to Speech

Comments

Post a Comment

Popular posts from this blog

ERP Management System Design

Image
ERP Management System Design Design and Develop Conceptual Data Model for an ERP Management System ER Diagram An Entity Relationship Diagram (ERD) displays the relationships of entity sets stored in a database. ER diagrams help explain the logical structure of databases, based on three basic concepts: Entities: Recognizable real-world things, either living or non-living, that are to be represented in the database. Attributes: Properties or details of an entity. Relationships: How entities interact with each other within the system. Enterprise Resource Planning (ERP) ERP is the integrated management of main business processes, often in real time, mediated by software. It is typically a suite of integrated applications that an organization uses to collect, store, manage, and interpret data from many business activities, and can be either local or cloud...
Read more

Database Management System

Image
Database Management System Write a query with a function of DDL commands such as create, alter and drop. DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. DDL is a set of SQL commands used to create, modify, and delete database structures but not data. List of DDL commands: CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers). QUERY: create table bca2 (stu_name varchar(6), stu_roll int, stu_marks number(7)); OUTPUT: DROP: This command is used to delete objects from the database. QUERY: drop table bca2; OUTPUT: ...
Read more

Use of order by statement.

Image
Use of ORDER BY Statement Use of order by statement The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword. Syntax* SELECT column1, column2, ... FROM table_name ORDER BY column1, column2, ... ASC|DESC; QUERY* CREATE TABLE stud_113 (Rollno NUMBER(5), name VARCHAR(10), address VARCHAR(15), phoneno NUMBER(10), age NUMBER(5)); As Shown in Fig...7.1 Output Fig... 7.1 QUERY* INSERT INTO stud_113 VALUES(3); INSERT INTO stud_113 VALUES(2); INSERT INTO stud_113 VALUES(5); INSERT INTO stud_113 VALUES(4); INSERT INTO stud_113 VALUES(1); INSERT INTO stud_113 VALUES(6); As Shown in Fig...7.2 Output Fig... 7.2 QUERY* SELECT * FROM stud_113 ORDER BY rollno DESC; As Shown in Fig...7.3 Output Fig... 7.3 Previous Next
Read more