Do Data Control Language commands include Grant and Revoke commands which is universal truth or does DCL includes Savepoint, Commit and Rollback?
Also mention how important are TCL commands -Transaction Control Language commands - Commit, Savepoint and Rollback.
Thanks Krunalkumar Shah
! This helps me to prove the organization where i work.Thanks a lot for your valuable reply.
Well Krunalkumar Shah
, the place i work state that DCL commands are Savepoint, Roll back and Commit from years to students. This is wrong is what i need to prove as it followed for years and all faculty do the same.Well i have other basic question to clear which they teach is wrong.
various SQL Action queries used to process transaction queries on various finance level applications.
in which you need to focus on Action quires.
Thanks Adnan Majeed ! Would you please elaborate the commands based on the Languages. Also, please mention the major SQL language which is used mainly for financial applications. This will help us to promote DataBases for BBA and MBA students.
yes, why not, please visit these following sites to see the SQL databases for financial applications, SQL database design to solves all disciplines application, such as CS, IT, Finance, Engineering, Marketing, Design anything web , desktop, mobile app, Intelligent finance application, but i recommend you to learn Python with SQL that great achievement for you
https://learnsql.com/blog/advanced-sql-queries-for-financial-analysis/
https://www.financialriskhub.com/sql-in-finance/
Dear RG Friends, I would like to draw your opinion on the databases in MSACCESS. As we discuss on SQL and DBMS, i wish to know on MSACCESS. How useful are the relationships and Queries in MSACCESS? Is MSACCESS useful for any financial or managerial position?
The relationships between database model entities are important because they represent connections between information (implemented with foreign keys in relational DBMS). I believe that there are better DBMS for financial investments.
Thanks Taciano Morais Silva ! Helping me to understand the significance of relationships specially for financial investment.
Structured Query Language (SQL) commands for accessing and managing data in a database management system (DBMS). A DBMS is the software that allows you access and manipulate the data found within the database. SQL is the database language used to perform a query, which is simply an inquiry.
Essentially, entering SQL commands in a DBMS is a three-step process which includes:
Gaining access to the DBMS
Requesting specific data to be returned from the DBMS
The DBMS providing the specifically indicated
Prisilla Jayanthi Gandam, I don't exactly know your doubt. But let's try to help!
In the entity-relationship model, relationships represent a link or role assumed by an entity's instance in another entity. You identify the relationships from the functional requirements described. For example: A bank account belongs to a customer (holder). And customer can have many accounts. So the relationship is one for many.
[Customer]-----(holder)-----[Account]
The account entity, when converted to Relational Model, will have a "title" attribute (foreign key) that references the Customer's primary key.
I found these two articles that can help, I recommend watching some video classes on youtube:
- https://www.guru99.com/er-diagram-tutorial-dbms.html
- https://www.guru99.com/relational-data-model-dbms.html
Thanks Taciano Morais Silva .
Well my doubt is simple. Is MSACCESS (db) useful for financial or management students? As it has all basic concepts of DB applicable to DBMS -SQL.
Taciano Morais Silva here is my recording for 1 to many relationship.
- Badges
- Science topic