The task is performed using the database that is hosted in this topic. To complete some tasks, you will need to attach screenshots of requests and received samples in accordance with the task. An important condition for responding to such tasks will be to attach a screenshot in which the name of the database will be visible (in the header at the very top).
!!! THE SCREENSHOT SHOULD BE ATTACHED AS AN ATTACHMENT, NOT IN A TEXT FIELD!!!
The name of the database should be in the format: Last name_number of the practical assignment.
Information about the task
It is necessary to create a database by uploading the following tables to SQLite: account, account_types, branches, clients, transaction, transaction_type and setting up links between them (specify foreign keys, as well as specify cascading deletion for foreign keys through modification of the table), which are reflected in the diagram below.
It is necessary to display information about the number of accounts in the context of each city, including in the sample only those cities where the number of accounts is 3 or more.

As a response to the task, attach a screenshot of the completed request in an attachment.
\begin{tabular}{rl}
Entities & \multicolumn{1}{c}{ Attributes } \
Branches & Branch_ID, Name, \
& Location, Manager \
& Client_ID, First_Name, \
& Last_Name, DOB (date \
of birth), Address, Age, \
& Sex, Created_Time, \
& Contact_no. \
& Account_ID, \
& Balance_account, \
Account & Status, Created_at, \
& Deleted_at, Client_ID, \
& Account_type_id, \
& Branch_ID \
& Transaction_ID, \
& Amount_Transactions, \
& Date_issued, Deposit, \
Transactions & Withdraw, Transfer, \
& Transactions_type_ID, \
& Source_Account_ID, \
& Destination_Account_ID \
& Account_type_ID, \
Account types & Description_Type \
& Transactions_type_ID, \
Transaction_type, \
Transaction type & Description, \
& Transaction_fee
\end{tabular}

Question

The task is performed using the database that is hosted in this topic. To complete some tasks, you will need to attach screenshots of requests and received samples in accordance with the task. An important condition for responding to such tasks will be to attach a screenshot in which the name of the database will be visible (in the header at the very top).
!!! THE SCREENSHOT SHOULD BE ATTACHED AS AN ATTACHMENT, NOT IN A TEXT FIELD!!!
The name of the database should be in the format: Last name_number of the practical assignment.
Information about the task
It is necessary to create a database by uploading the following tables to SQLite: account, account_types, branches, clients, transaction, transaction_type and setting up links between them (specify foreign keys, as well as specify cascading deletion for foreign keys through modification of the table), which are reflected in the diagram below.
It is necessary to display information about the number of accounts in the context of each city, including in the sample only those cities where the number of accounts is 3 or more.

As a response to the task, attach a screenshot of the completed request in an attachment.
\begin{tabular}{rl} 
Entities & \multicolumn{1}{c}{ Attributes } \
Branches & Branch_ID, Name, \
& Location, Manager \
& Client_ID, First_Name, \
& Last_Name, DOB (date \
of birth), Address, Age, \
& Sex, Created_Time, \
& Contact_no. \
& Account_ID, \
& Balance_account, \
Account & Status, Created_at, \
& Deleted_at, Client_ID, \
& Account_type_id, \
& Branch_ID \
& Transaction_ID, \
& Amount_Transactions, \
& Date_issued, Deposit, \
Transactions & Withdraw, Transfer, \
& Transactions_type_ID, \
& Source_Account_ID, \
& Destination_Account_ID \
& Account_type_ID, \
Account types & Description_Type \
& Transactions_type_ID, \
Transaction_type, \
Transaction type & Description, \
& Transaction_fee
\end{tabular}

Accepted Answer

It looks like you're working on a database schema related to a banking or financial system. From the images and descriptions you've provided, it seems you need to create a database in SQLite with several tables and their relationships. To summarize the key points: 1. **Tables to Create**: - **Transaction_type**: Holds different types of transactions. - **Transaction**: Contains details about individual transactions. - **Account**: Stores account information. - **Account_types**: Holds various account types. - **Branches**: Contains information about different branches. - **Clients**: Stores client information. 2. **Relationships**: - Ensure that foreign keys are set up correctly to link these tables. For example, the `Transaction` table references `Transaction_type`, and the `Account` table references `Account_types`, `Branches`, and `Clients`. 3. **Cascading Deletion**: - Modify the tables to specify cascading deletion for foreign keys, which means if a record in a parent table is deleted, the corresponding records in the child tables will also be deleted automatically. 4. **Query Requirement**: - You need to display the number of accounts per city, filtering for cities with three or more accounts. Make sure to take a screenshot of your database setup and the query results as required. If you have any specific questions about how to implement any of these steps or need help with SQL queries, feel free to ask!

Sia