Database Systems and Design Assignment

Added on - 17 Feb 2021

  • 19

    pages

  • 1237

    Words

  • 7

    Views

  • 0

    Downloads

Showing pages 1 to 4 of 19 pages
DATABASE SYSTEMS ANDDESIGN
Table of ContentsINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................11.1 Selection of a case study for designing and implementation of a data base.....................11.2 Creation of ER diagram with details................................................................................2TASK 2............................................................................................................................................32.1 Logical database design according to the case study.......................................................32.2 Creation of database table................................................................................................72.3 Four useful indexes in tables............................................................................................92.4 Data population..............................................................................................................102.5 SQL query writing..........................................................................................................10CONCLUSION..............................................................................................................................15
INTRODUCTIONA database can simply be defined as a collection of data that is generally accessed orstored electronically from a computer systems. There are many types of database available out ofwhich here oracle SQL developer has been used. In this assignment a database will be createdbased on operations of a bank. According to bank case study here six tables will be created withsome data inserted in it. After insertion of data some SQL queries will be fired to achieve theresult.TASK 11.1 Selection of a case study for designing and implementation of a data baseFor this database designing and implementation assignment a bank and its operationscase study has been taken which consist of banker and their customer information (Nguyen andet.al., 2018). It also consists of Transaction, account details, credit card details and loan details(if taken by customers). It has one generalisation/specialization structure i.e. customer has acredit card and an account.Generalisationis a process of extracting shared characteristics from more than one classes.Those classes can also be combined into a generalized super class. It occurs when differencesbetween two classes is ignored and similarities between lower entities are acknowledged to forma higher entity. It is a bottom to up process (Eastman, 2018).Specialisationis a process of creating sub classes from an existing class. It is a top to downprocess. It also splits an entity to form multiple new entities that inherit some features of splittingentity. It is applied on single entity.(a) Relevant background information on the organization:A bank is an organization which involves saving, borrowing and lending of money to itscustomers. They provide customers loan of a fixed amount, offers to save their deposits in returnfor paying an annual interest payment to customers. A bank has many operations but its mainprinciple operations are cash withdraw, cash deposit, providing loan and saving deposit ofcustomers. Its target customers are lower value, middle value and higher vale customers, also allthe customers who has closed their accounts in the bank (Pei and et.al., 2018).(b) operations supported by customersThis database support transaction, account, providing credit card, loan related operationof all the customers.1
1.2 Creation of ER diagram with detailsIn this ER diagram there are five strong entities and one weak entity. Banker, customer, account,loan and credit card are the strong entities and transaction is the weak entity as it is dependent onthe customer(Zhang and et.al., 2018). There are many entities in this diagram that consist of aprimary key likeEntitiesAttributesBankerbanker_id ( Primary Key )Banker_emailbanker-nameCustomerscust_id ( Primary key )cust_namecust_addressaccount_noAccountaccount no( Primary key )2
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document