---
# System prepended metadata

title: '[Database Management System - Group 5](https://docs.google.com/document/d/1g8xnaHsVF_MpbGV_KSx5AuEgzxOLatxaH_UuDezquh0/edit?usp=sharing)'
tags: [HK221]

---

###### tags: `HK221`
# [Database Management System - Group 5](https://docs.google.com/document/d/1g8xnaHsVF_MpbGV_KSx5AuEgzxOLatxaH_UuDezquh0/edit?usp=sharing)

## Assesment
![](https://i.imgur.com/7kk37Pb.png)

## Take notes
- [Minh](https://docs.google.com/document/d/1g8xnaHsVF_MpbGV_KSx5AuEgzxOLatxaH_UuDezquh0/edit?usp=sharing)


## DBMS
- MS SQL Server
- MongoDB
## Requirement
- Indexing
    - Study the materials of each DBMS about index types
    - Study the materials of each DBMS about index structures used for each index type
    - Compare their indexing supports
    - Apply their indexing supports to your application
- Transaction processing
    - Study the materials of the relational DBMS about transactions and transaction processing
    - Apply the transaction processing supports of the relational DBMS to your application


# Mongodb indexes

![](https://www.mongodb.com/docs/manual/images/index-for-sort.bakedsvg.svg)

## Default _id Index
- _id index prevents clients from inserting two documents with the same value for the _id field
- ```db.collection.create_index([(<key and index type specification>)], <options> )```

## Index Types
### Single Field
![](https://www.mongodb.com/docs/manual/images/index-ascending.bakedsvg.svg)

### Compond Index
![](https://www.mongodb.com/docs/manual/images/index-compound-key.bakedsvg.svg)

### Multikey Index
![](https://www.mongodb.com/docs/manual/images/index-multikey.bakedsvg.svg)


# MS Server Indexing

## Index types

### Hash
![](https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/media/hekaton-tables-23d.png?view=sql-server-ver16)


### Clustered

![](https://learn.microsoft.com/en-us/sql/relational-databases/media/bokind2.gif?view=sql-server-ver16)



### Nonclustered
![](https://learn.microsoft.com/en-us/sql/relational-databases/media/bokind1a.gif?view=sql-server-ver16)



## Transaction

- [ref](https://learn.microsoft.com/en-us/sql/t-sql/language-elements/transactions-transact-sql?view=sql-server-ver16)





# References

- [Indexes - SQL server | Microsoft Learn](https://learn.microsoft.com/en-us/sql/relational-databases/indexes/indexes?view=sql-server-ver16)
- [Transactions (Transact-SQL) | Microsoft Learn](https://learn.microsoft.com/en-us/sql/t-sql/language-elements/transactions-transact-sql?view=sql-server-ver16)
- [Build a CRUD app with nodejs and mongodb](https://blog.appsignal.com/2022/08/17/build-a-crud-app-with-nodejs-and-mongodb.html)
- [Build CRUD application with asp net core entity framework visual studio 2019](https://www.syncfusion.com/blogs/post/build-crud-application-with-asp-net-core-entity-framework-visual-studio-2019.aspx)