logo

Database Management System | Assignment Sample

   

Added on  2021-04-24

16 Pages2118 Words39 Views
Running head: DATABASE MANAGEMENT SYSTEMDatabase Management SystemName of studentName of UniversityAuthor’s Note

1DATABASE MANAGEMENT SYSTEMTable of Contents1. Concept of Relational Database...................................................................................................2a) Relational Data Structure:.......................................................................................................2b) About Attributes and Tuples:..................................................................................................2c) Rows, Columns and Tables:....................................................................................................3d) View:.......................................................................................................................................42. Features of a Relational and Non-Relational Database Management System:...........................53. (a) DML codes to create:............................................................................................................8(b) DML codes to insert:............................................................................................................10(c) SQL integrity features:.........................................................................................................11

2DATABASE MANAGEMENT SYSTEM1. Concept of Relational Databasea) Relational Data Structure:Figure 1: Relation DiagramSource: Authorb) About Attributes and Tuples:In the Student Relation of figure 1, tuple is a row. Here, it has 5 tuples with 6 values that iscalled as 6 tuples. In general, n- tuples has a list ordered of values n. If t1 is refer to first tuplevariable for the relation STUDENT, then t1 = <S10010, Chan Wai Yee, 56A, Jalan 2/14, TamanMidah, kuala Lampur, 012-3256780, F, wai99@yahoo.com>, similarly for the other. Tuples mayappear in sorted or unsorted order. The relations of the order remain the same and give sameinformation or meaning.

3DATABASE MANAGEMENT SYSTEMAttribute is the relation characteristic of a column. In figure 1, the relation of STUDENTconsists of 7 attributes namely, id (the student ID), sName, Address, State, Contact Number, Sex,Email.Similarities The relation tuple are similar to the file records, and attributes are field that are analogues(McGinnes and Kapros 2015).DifferenceThe model of relational database is logically related to tables that contain data. Attribute isa column were particular kind of data are kept; tuple is a row that holds the particular event orentity of the relation data. c) Rows, Columns and Tables:In a relational database concept, tables have a rows and a column. In the table, each of the rowswill represent the related values of the collection (Keith et al. 2018). The information of the objectis hold in the database to represent in the table. In any specific table, data has one kind of objectscalled the entities. Table is actually a concept of the data and relation is the concept of relationalmodel.Now in a table each of the rows represents one object called the entity that is the collection of therelated values. If the diagram of figure 1 is considered, it has the data of one customer in one of therow in Student table. Thus, row has considered as a database concept and tuple as the concept ofrelational model.

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Collection of Logically Related Data - Desklib
|6
|563
|99

Components of DBMS - Doc
|6
|730
|205

Importance of Database Management System (DBMS) and Transportation Management System (TMS) in MIS
|8
|1655
|179

Database Modelling and Normalization for Desklib
|10
|1157
|79

Database Design for Universal Sport Company
|18
|1222
|75

Entity Relationship Diagram in Library Management System
|25
|2195
|76