×
Log in to StudySoup
Get Full Access to UTA - Study Guide - Midterm
Join StudySoup for FREE
Get Full Access to UTA - Study Guide - Midterm

Already have an account? Login here
×
Reset your password

UTA / Computer Science and Engineering / CSE 5330 / What does the term database application refer to?

What does the term database application refer to?

What does the term database application refer to?

Description

ol.lst-kix_jixxoj3111dt-4{list-style-type:none}ol.lst-kix_jixxoj3111dt-3{list-style-type:none}ol.lst-kix_jixxoj3111dt-6{list-style-type:none}ol.lst-kix_jixxoj3111dt-5{list-style-type:none}.lst-kix_6t2q9zlrgdiy-6 > li:before{content:"- "}.lst-kix_6t2q9zlrgdiy-8 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-0{list-style-type:none}ol.lst-kix_jixxoj3111dt-2{list-style-type:none}ol.lst-kix_jixxoj3111dt-1{list-style-type:none}.lst-kix_6t2q9zlrgdiy-5 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-8{list-style-type:none}ol.lst-kix_jixxoj3111dt-7{list-style-type:none}.lst-kix_6t2q9zlrgdiy-7 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-1 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-0 > li:before{content:"- "}ul.lst-kix_9k9zy5vnhm7h-8{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-5{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-4{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-7{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-6{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-2{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-1{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-0{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-6{list-style-type:none}ul.lst-kix_pgnanjm8600o-0{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-5{list-style-type:none}ul.lst-kix_pgnanjm8600o-1{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-4{list-style-type:none}ul.lst-kix_pgnanjm8600o-2{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-3{list-style-type:none}ul.lst-kix_pgnanjm8600o-3{list-style-type:none}ul.lst-kix_pgnanjm8600o-4{list-style-type:none}ul.lst-kix_pgnanjm8600o-5{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-8{list-style-type:none}ul.lst-kix_pgnanjm8600o-6{list-style-type:none}ul.lst-kix_l0hlkbuwfu17-7{list-style-type:none}ul.lst-kix_pgnanjm8600o-7{list-style-type:none}.lst-kix_jixxoj3111dt-0 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-0}ul.lst-kix_pgnanjm8600o-8{list-style-type:none}.lst-kix_6t2q9zlrgdiy-0 > li:before{content:"- "}.lst-kix_6t2q9zlrgdiy-1 > li:before{content:"- "}.lst-kix_6t2q9zlrgdiy-2 > li:before{content:"- "}.lst-kix_6t2q9zlrgdiy-4 > li:before{content:"- "}.lst-kix_6t2q9zlrgdiy-3 > li:before{content:"- "}.lst-kix_tshhbmhpf94f-0 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-5.start{counter-reset:lst-ctn-kix_jixxoj3111dt-5 0}ul.lst-kix_nj64e7ja5t6k-8{list-style-type:none}.lst-kix_tshhbmhpf94f-4 > li:before{content:"- "}.lst-kix_tshhbmhpf94f-5 > li:before{content:"- "}ul.lst-kix_nj64e7ja5t6k-7{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-6{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-5{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-4{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-3{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-2{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-1{list-style-type:none}.lst-kix_tshhbmhpf94f-1 > li:before{content:"- "}ul.lst-kix_lghzvja4rqci-6{list-style-type:none}ul.lst-kix_nj64e7ja5t6k-0{list-style-type:none}ul.lst-kix_lghzvja4rqci-7{list-style-type:none}.lst-kix_tshhbmhpf94f-2 > li:before{content:"- "}ul.lst-kix_lghzvja4rqci-4{list-style-type:none}ul.lst-kix_jpjj3ntphbah-8{list-style-type:none}ul.lst-kix_lghzvja4rqci-5{list-style-type:none}ul.lst-kix_jpjj3ntphbah-7{list-style-type:none}.lst-kix_tshhbmhpf94f-3 > li:before{content:"- "}ul.lst-kix_lghzvja4rqci-2{list-style-type:none}ul.lst-kix_jpjj3ntphbah-6{list-style-type:none}ul.lst-kix_lghzvja4rqci-3{list-style-type:none}ul.lst-kix_jpjj3ntphbah-5{list-style-type:none}ul.lst-kix_lghzvja4rqci-0{list-style-type:none}ul.lst-kix_jpjj3ntphbah-4{list-style-type:none}.lst-kix_pgnanjm8600o-6 > li:before{content:"- "}ul.lst-kix_lghzvja4rqci-1{list-style-type:none}ul.lst-kix_jpjj3ntphbah-3{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-1{list-style-type:none}ul.lst-kix_jpjj3ntphbah-2{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-0{list-style-type:none}ul.lst-kix_jpjj3ntphbah-1{list-style-type:none}ul.lst-kix_9k9zy5vnhm7h-3{list-style-type:none}ul.lst-kix_jpjj3ntphbah-0{list-style-type:none}.lst-kix_pgnanjm8600o-7 > li:before{content:"- "}ul.lst-kix_9k9zy5vnhm7h-2{list-style-type:none}.lst-kix_pgnanjm8600o-8 > li:before{content:"- "}.lst-kix_tshhbmhpf94f-8 > li:before{content:"- "}.lst-kix_tshhbmhpf94f-6 > li:before{content:"- "}.lst-kix_tshhbmhpf94f-7 > li:before{content:"- "}.lst-kix_jixxoj3111dt-7 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-7}ol.lst-kix_jixxoj3111dt-4.start{counter-reset:lst-ctn-kix_jixxoj3111dt-4 0}.lst-kix_nj64e7ja5t6k-5 > li:before{content:"- "}.lst-kix_jixxoj3111dt-7 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-7,lower-latin) ". "}.lst-kix_a751ful2d0c4-3 > li:before{content:"- "}.lst-kix_nj64e7ja5t6k-1 > li:before{content:"- "}ul.lst-kix_q7mpujoqml2o-0{list-style-type:none}.lst-kix_jixxoj3111dt-3 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-3,decimal) ". "}.lst-kix_jixxoj3111dt-5 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-5,lower-roman) ". "}ul.lst-kix_q7mpujoqml2o-3{list-style-type:none}.lst-kix_nj64e7ja5t6k-3 > li:before{content:"- "}.lst-kix_a751ful2d0c4-1 > li:before{content:"- "}ul.lst-kix_q7mpujoqml2o-4{list-style-type:none}ul.lst-kix_q7mpujoqml2o-1{list-style-type:none}ul.lst-kix_q7mpujoqml2o-2{list-style-type:none}ul.lst-kix_2w3zspb5jl1-7{list-style-type:none}.lst-kix_jixxoj3111dt-3 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-3}ul.lst-kix_2w3zspb5jl1-6{list-style-type:none}.lst-kix_jixxoj3111dt-1 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-1,lower-latin) ". "}ul.lst-kix_2w3zspb5jl1-8{list-style-type:none}.lst-kix_nj64e7ja5t6k-7 > li:before{content:"- "}.lst-kix_q7mpujoqml2o-3 > li:before{content:"- "}.lst-kix_jixxoj3111dt-2 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-2}.lst-kix_q7mpujoqml2o-1 > li:before{content:"- "}.lst-kix_q7mpujoqml2o-5 > li:before{content:"- "}.lst-kix_pgnanjm8600o-4 > li:before{content:"- "}ul.lst-kix_lghzvja4rqci-8{list-style-type:none}.lst-kix_q7mpujoqml2o-7 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-6.start{counter-reset:lst-ctn-kix_jixxoj3111dt-6 0}.lst-kix_pgnanjm8600o-2 > li:before{content:"- "}.lst-kix_a751ful2d0c4-7 > li:before{content:"- "}.lst-kix_pgnanjm8600o-0 > li:before{content:"- "}.lst-kix_a751ful2d0c4-5 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-0 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-2 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-4 > li:before{content:"- "}.lst-kix_m077kwlsq1ab-7 > li:before{content:"- "}.lst-kix_vxz6elgco18v-0 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-6 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-0 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-8 > li:before{content:"- "}ul.lst-kix_tshhbmhpf94f-8{list-style-type:none}.lst-kix_2w3zspb5jl1-3 > li:before{content:"- "}ul.lst-kix_tshhbmhpf94f-6{list-style-type:none}ul.lst-kix_tshhbmhpf94f-7{list-style-type:none}ul.lst-kix_tshhbmhpf94f-4{list-style-type:none}.lst-kix_2w3zspb5jl1-5 > li:before{content:"- "}ul.lst-kix_tshhbmhpf94f-5{list-style-type:none}ul.lst-kix_tshhbmhpf94f-2{list-style-type:none}ul.lst-kix_tshhbmhpf94f-3{list-style-type:none}ul.lst-kix_tshhbmhpf94f-0{list-style-type:none}.lst-kix_2w3zspb5jl1-7 > li:before{content:"- "}ul.lst-kix_tshhbmhpf94f-1{list-style-type:none}.lst-kix_l0hlkbuwfu17-1 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-2 > li:before{content:"- "}ul.lst-kix_4vk8f688x1tp-6{list-style-type:none}ol.lst-kix_jixxoj3111dt-8.start{counter-reset:lst-ctn-kix_jixxoj3111dt-8 0}ul.lst-kix_4vk8f688x1tp-5{list-style-type:none}ul.lst-kix_4vk8f688x1tp-8{list-style-type:none}ul.lst-kix_4vk8f688x1tp-7{list-style-type:none}.lst-kix_jpjj3ntphbah-7 > li:before{content:"- "}ul.lst-kix_4vk8f688x1tp-0{list-style-type:none}ul.lst-kix_2w3zspb5jl1-1{list-style-type:none}ul.lst-kix_2w3zspb5jl1-0{list-style-type:none}.lst-kix_vxz6elgco18v-8 > li:before{content:"- "}ul.lst-kix_4vk8f688x1tp-2{list-style-type:none}ul.lst-kix_2w3zspb5jl1-3{list-style-type:none}ul.lst-kix_4vk8f688x1tp-1{list-style-type:none}ul.lst-kix_2w3zspb5jl1-2{list-style-type:none}ul.lst-kix_4vk8f688x1tp-4{list-style-type:none}ul.lst-kix_2w3zspb5jl1-5{list-style-type:none}ul.lst-kix_4vk8f688x1tp-3{list-style-type:none}ul.lst-kix_2w3zspb5jl1-4{list-style-type:none}.lst-kix_m077kwlsq1ab-5 > li:before{content:"- "}.lst-kix_vxz6elgco18v-2 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-8 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-3 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-6 > li:before{content:"- "}.lst-kix_m077kwlsq1ab-1 > li:before{content:"- "}.lst-kix_vxz6elgco18v-6 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-5 > li:before{content:"- "}.lst-kix_m077kwlsq1ab-3 > li:before{content:"- "}.lst-kix_vxz6elgco18v-4 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-4 > li:before{content:"- "}.lst-kix_4vk8f688x1tp-3 > li:before{content:"- "}.lst-kix_4vk8f688x1tp-5 > li:before{content:"- "}.lst-kix_4vk8f688x1tp-2 > li:before{content:"- "}.lst-kix_4vk8f688x1tp-6 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-7.start{counter-reset:lst-ctn-kix_jixxoj3111dt-7 0}.lst-kix_4vk8f688x1tp-4 > li:before{content:"- "}.lst-kix_4vk8f688x1tp-7 > li:before{content:"- "}.lst-kix_4vk8f688x1tp-8 > li:before{content:"- "}.lst-kix_l0hlkbuwfu17-5 > li:before{content:"- "}.lst-kix_l0hlkbuwfu17-7 > li:before{content:"- "}.lst-kix_l0hlkbuwfu17-6 > li:before{content:"- "}.lst-kix_l0hlkbuwfu17-3 > li:before{content:"- "}.lst-kix_jixxoj3111dt-8 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-8}.lst-kix_l0hlkbuwfu17-4 > li:before{content:"- "}.lst-kix_2w3zspb5jl1-2 > li:before{content:"- "}.lst-kix_2w3zspb5jl1-1 > li:before{content:"- "}ul.lst-kix_vxz6elgco18v-8{list-style-type:none}ul.lst-kix_vxz6elgco18v-6{list-style-type:none}ul.lst-kix_vxz6elgco18v-7{list-style-type:none}ul.lst-kix_vxz6elgco18v-4{list-style-type:none}.lst-kix_2w3zspb5jl1-0 > li:before{content:"- "}ul.lst-kix_vxz6elgco18v-5{list-style-type:none}.lst-kix_4vk8f688x1tp-1 > li:before{content:"- "}ul.lst-kix_vxz6elgco18v-2{list-style-type:none}ul.lst-kix_vxz6elgco18v-3{list-style-type:none}ul.lst-kix_vxz6elgco18v-0{list-style-type:none}ul.lst-kix_vxz6elgco18v-1{list-style-type:none}.lst-kix_4vk8f688x1tp-0 > li:before{content:"- "}.lst-kix_l0hlkbuwfu17-8 > li:before{content:"- "}.lst-kix_jixxoj3111dt-1 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-1}.lst-kix_lghzvja4rqci-4 > li:before{content:"- "}.lst-kix_lghzvja4rqci-3 > li:before{content:"- "}.lst-kix_lghzvja4rqci-7 > li:before{content:"- "}.lst-kix_lghzvja4rqci-0 > li:before{content:"- "}.lst-kix_lghzvja4rqci-8 > li:before{content:"- "}.lst-kix_lghzvja4rqci-2 > li:before{content:"- "}.lst-kix_lghzvja4rqci-1 > li:before{content:"- "}ul.lst-kix_m077kwlsq1ab-8{list-style-type:none}ul.lst-kix_a751ful2d0c4-1{list-style-type:none}ul.lst-kix_q7mpujoqml2o-7{list-style-type:none}ul.lst-kix_a751ful2d0c4-2{list-style-type:none}ul.lst-kix_q7mpujoqml2o-8{list-style-type:none}ul.lst-kix_m077kwlsq1ab-6{list-style-type:none}ul.lst-kix_a751ful2d0c4-3{list-style-type:none}ul.lst-kix_q7mpujoqml2o-5{list-style-type:none}ul.lst-kix_m077kwlsq1ab-7{list-style-type:none}ul.lst-kix_a751ful2d0c4-4{list-style-type:none}ul.lst-kix_q7mpujoqml2o-6{list-style-type:none}ul.lst-kix_m077kwlsq1ab-4{list-style-type:none}ul.lst-kix_m077kwlsq1ab-5{list-style-type:none}ul.lst-kix_m077kwlsq1ab-2{list-style-type:none}ul.lst-kix_m077kwlsq1ab-3{list-style-type:none}ul.lst-kix_a751ful2d0c4-0{list-style-type:none}ul.lst-kix_m077kwlsq1ab-0{list-style-type:none}.lst-kix_jixxoj3111dt-4 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-4}ul.lst-kix_m077kwlsq1ab-1{list-style-type:none}.lst-kix_lghzvja4rqci-6 > li:before{content:"- "}ul.lst-kix_a751ful2d0c4-5{list-style-type:none}ul.lst-kix_a751ful2d0c4-6{list-style-type:none}.lst-kix_lghzvja4rqci-5 > li:before{content:"- "}ul.lst-kix_a751ful2d0c4-7{list-style-type:none}ul.lst-kix_a751ful2d0c4-8{list-style-type:none}.lst-kix_nj64e7ja5t6k-4 > li:before{content:"- "}.lst-kix_a751ful2d0c4-0 > li:before{content:"- "}.lst-kix_jixxoj3111dt-6 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-6,decimal) ". "}.lst-kix_a751ful2d0c4-2 > li:before{content:"- "}.lst-kix_nj64e7ja5t6k-2 > li:before{content:"- "}.lst-kix_jixxoj3111dt-4 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-4,lower-latin) ". "}.lst-kix_jixxoj3111dt-2 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-2,lower-roman) ". "}.lst-kix_nj64e7ja5t6k-8 > li:before{content:"- "}.lst-kix_nj64e7ja5t6k-6 > li:before{content:"- "}.lst-kix_jixxoj3111dt-0 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-0,decimal) ". "}ol.lst-kix_jixxoj3111dt-0.start{counter-reset:lst-ctn-kix_jixxoj3111dt-0 0}.lst-kix_q7mpujoqml2o-4 > li:before{content:"- "}.lst-kix_pgnanjm8600o-5 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-3.start{counter-reset:lst-ctn-kix_jixxoj3111dt-3 0}.lst-kix_jixxoj3111dt-5 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-5}.lst-kix_q7mpujoqml2o-2 > li:before{content:"- "}.lst-kix_q7mpujoqml2o-6 > li:before{content:"- "}ul.lst-kix_6t2q9zlrgdiy-8{list-style-type:none}.lst-kix_pgnanjm8600o-3 > li:before{content:"- "}ul.lst-kix_6t2q9zlrgdiy-7{list-style-type:none}ul.lst-kix_6t2q9zlrgdiy-6{list-style-type:none}.lst-kix_q7mpujoqml2o-0 > li:before{content:"- "}.lst-kix_q7mpujoqml2o-8 > li:before{content:"- "}ul.lst-kix_6t2q9zlrgdiy-5{list-style-type:none}ul.lst-kix_6t2q9zlrgdiy-4{list-style-type:none}ul.lst-kix_6t2q9zlrgdiy-3{list-style-type:none}ul.lst-kix_6t2q9zlrgdiy-2{list-style-type:none}ul.lst-kix_6t2q9zlrgdiy-1{list-style-type:none}ul.lst-kix_6t2q9zlrgdiy-0{list-style-type:none}.lst-kix_a751ful2d0c4-6 > li:before{content:"- "}.lst-kix_a751ful2d0c4-8 > li:before{content:"- "}.lst-kix_pgnanjm8600o-1 > li:before{content:"- "}.lst-kix_nj64e7ja5t6k-0 > li:before{content:"- "}.lst-kix_a751ful2d0c4-4 > li:before{content:"- "}.lst-kix_jixxoj3111dt-8 > li:before{content:"" counter(lst-ctn-kix_jixxoj3111dt-8,lower-roman) ". "}ol.lst-kix_jixxoj3111dt-2.start{counter-reset:lst-ctn-kix_jixxoj3111dt-2 0}ul.lst-kix_1ax4hdg4h4k2-0{list-style-type:none}.lst-kix_1ax4hdg4h4k2-1 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-3 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-3 > li:before{content:"- "}ul.lst-kix_1ax4hdg4h4k2-8{list-style-type:none}ul.lst-kix_1ax4hdg4h4k2-7{list-style-type:none}.lst-kix_m077kwlsq1ab-8 > li:before{content:"- "}ul.lst-kix_1ax4hdg4h4k2-6{list-style-type:none}ul.lst-kix_1ax4hdg4h4k2-5{list-style-type:none}ul.lst-kix_1ax4hdg4h4k2-4{list-style-type:none}ul.lst-kix_1ax4hdg4h4k2-3{list-style-type:none}ul.lst-kix_1ax4hdg4h4k2-2{list-style-type:none}.lst-kix_9k9zy5vnhm7h-5 > li:before{content:"- "}ul.lst-kix_1ax4hdg4h4k2-1{list-style-type:none}.lst-kix_2w3zspb5jl1-4 > li:before{content:"- "}.lst-kix_jixxoj3111dt-6 > li{counter-increment:lst-ctn-kix_jixxoj3111dt-6}.lst-kix_l0hlkbuwfu17-2 > li:before{content:"- "}.lst-kix_2w3zspb5jl1-6 > li:before{content:"- "}.lst-kix_2w3zspb5jl1-8 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-1 > li:before{content:"- "}.lst-kix_l0hlkbuwfu17-0 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-8 > li:before{content:"- "}ol.lst-kix_jixxoj3111dt-1.start{counter-reset:lst-ctn-kix_jixxoj3111dt-1 0}.lst-kix_m077kwlsq1ab-0 > li:before{content:"- "}.lst-kix_vxz6elgco18v-7 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-2 > li:before{content:"- "}.lst-kix_m077kwlsq1ab-4 > li:before{content:"- "}.lst-kix_m077kwlsq1ab-6 > li:before{content:"- "}.lst-kix_vxz6elgco18v-1 > li:before{content:"- "}.lst-kix_vxz6elgco18v-3 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-7 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-4 > li:before{content:"- "}.lst-kix_9k9zy5vnhm7h-7 > li:before{content:"- "}.lst-kix_1ax4hdg4h4k2-5 > li:before{content:"- "}.lst-kix_jpjj3ntphbah-6 > li:before{content:"- "}.lst-kix_m077kwlsq1ab-2 > li:before{content:"- "}.lst-kix_vxz6elgco18v-5 > li:before{content:"- "}

Data Modelling Using The ER ModelWe also discuss several other topics like How do you find the implicit solution?

  • The term database application refers to a particular database and the associated programs that implement the database queries and updates.
  • The Entity-relationship (ER) model is a popular high-level conceptual data model.
  • Diagrammatic notation associated with the ER model is known as ER diagram.

We also discuss several other topics like What does american exceptionalism mean?

High-Level Conceptual Data Models for Database Design

  • The database design process is,
  • First Step: - Requirement collection and Analysis

During this step, database designers interview prospective database users to understand and document their data requirements.

  • Along with data requirements and functional requirements are also captured which consists of operations/transactions that will be applied to the database - i.e. retrieval and updates
  • Data flow diagrams, sequence diagrams, scenarios and other techniques are used to specify functional requirements.
  • Next Step: -create conceptual schema for the DB using high-level conceptual data model.

This step is called conceptual design.

  • Conceptual schema includes entity types, relationships and constraints
  • High level conceptual schema is used to ensure all user requirements are met and do not conflict.
  • After conceptual schema design, basic data model operations are used to specify high-level user operations and queries specified in the functional analysis.
  • Next step: - Actual Implementation of database: -Implementation data model-relational, model is used to transform high level data model to implementation data model.

This step is called Logical Design  or Data Model Mapping.

  • Last Step: -Physical Design Phase

Internal storage structure, file organizations, indexes, access paths and physical design parameters for database files are specified.

  • Application programs are designed and implemented as database transactions corresponding to the high-next-level transaction specifications.

We also discuss several other topics like What do you think is the significance of the cross and the helicopter during the opening scene of the movie?
Don't forget about the age old question of What sum is expressed in amu per particle?

Entity Types, Entity sets, Attributes and KeysIf you want to learn more check out What is the main aim of social work?

  • The ER model describes data as entities, relationships and attributes.

Entity and Attributes:-

        Entity is a string of objects in the real world with an independent existence.If you want to learn more check out How do you find the limiting reactant and excess?

Entity has attributes - particular properties that describe it. Attribute describe each entity and become a major part of data stored in DB.

  • Several types of attributes occur in ER Model.

  1. Composite vs. Simple (Atomic) Attributes
  • Composite attributes can be divided into smaller subparts - which represent more basic attributes with independent meanings.

e.g. : - Addresses are subdivided into street-address, city, state and zip.

  • Attribute that are not divisible are called simple or atomic attributes
  • Composite attributes can form a hierarchy.

E.g. Street-address can be subdivided into three simple components: Number, street, Apartment number.

  1. Single-Valued versus Multivalued Attributes
  • Attributes that have a single value for a particular entity are called single-valued.

e.g. Age is single-valued.

  • Some attributes can have a set of values for the same entity, such attributes are called multivalued.
  • Multivalued attributes can have lower and upper bounds to constrain the number of values.

  1. Stored vs. Derived Attributes
  • Value of Age can be determined from the current date and the value of the person's Birth-date. The Age attribute is hence called a derived attribute, and is derivable from Birth-date attribute, which is called a stored attribute.

  1. Null values -
  • In some cases, a particular entity may not have an applicable value for an attribute.

e.g. - college-degrees attribute applies only to people with college degrees, for such situations, a special value called NULL is created.

Page Expired
5off
It looks like your free minutes have expired! Lucky for you we have all the content you need, just sign up here