Data Models Assignment Data modelling
PROGRAMMING ASSIGNMENTS HELP www.programmingassignmentshelp.net
1
P1. Understand data models and database technologies P1.1- Measure different data models such as network, hierarchy, RDBMS etc. and schemas such as external, conceptual etc. Data model defined as the set of conceptual collection that describes and decides the architectural design of any database system. With the design, structure of database also described with the data models such as data types and their relationship. Data models plays important role for any software application. The data model helps in the development of database system for any web application. A database system relies on the data modelling approach, chosen for development of the application. Data models helps in the managing the work flows and understanding of the system. It is chosen and designed after proper observation of (case study) a system for whom it is developing. Data analysis task has been done after the data structure development. Data models can be created for existing systems to improvise the data relationship, removal of any present bug. To make database better knowledge of different model is essentials. A data schema is a structured representation of planned database. With the data schema, the data structure is defined. Data structure is a way to manage the relationship between the different data structures. The data structure can be understood with the data schema representation of the database. (Brackett, 2013) Record based logical model has following models:
Object-oriented model Relational Database model Network model Hierarchical model Associative model
Object-oriented model: This model is specific to the project or applications that are developed in object oriented model. Object database is developed using this model. The high featured database is developed with this model. The object oriented model is implemented with the OOP concepts and principles. The object oriented model is implemented in C sharp, java and other object oriented platforms. Relational model: relational database is developed with this model. In this model all data is stored in the table that are interrelated. In this model each relation is made with the header and body. The header includes the list of column from the relation. The body of the relation populates from the
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
2
rows. The junction of unique row and column is a called tuple. The DATALYTICS database is to be developed with this model. Hierarchical model: when the database required being in the hierarchy format this model has been implemented. In this data model table relationship is maintained in the parent-child relationships. The mapping of database has been model with the 1: N relationship model. The parent table can manage the more than one child table. Network model: Network model is next part of the hierarchy model. In this model, the network of table or relations is maintained. The network model manages the 1: M relationship throughout the network of tables. The development of network model is based on the mathematical set theory. Network model consists the relationship includes the name, parent and child record type. Associative model: Associative data model is developed with the respect of object syntax. The entities of the table are managed with the live object. The data structures are implemented with link and items. The all entities are associated with the all other tables. The associative model compromises data structures in two ways. First are the items set managed with the unique identifier i.e. name and type. Second is a unique identifier has three things. (Unixspace.com, 2015)
P1.2- Examine the Advantages and Boundaries of different database technologies such MS Access, SQL Server, Oracle etc. SQL Server Advantages:
SQL Server (MSSQL) is an open source, free SQL Server database is secure. User gets the permission to access the database by only a small set of views. User’s access to stored data is restricted and they can access it only via valid login credentials Queries can be executed simply. Views can be used to fetch data from multiple tables. Views give an option to personalize the database Data stored in MSSQL database follows integrity constraints and is consistent.
Disadvantages There are some update restrictions and performance issues related to MSSQL. Views are an representation of tables but the database management system needs to translate the queries against the view into queries against the underlying tables. (C-sharpcorner, 2015)
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
3
MS Access Advantages
Microsoft Access is easy to install and use. It is a fully functional database management system that provides facility of wizards and helps us get through the software in minutes. MS Access can easily integrated with .Net applications It has a fully interactive user interface with easy functionality, it can be setup easily MS Access is widely popular database management system in the world It offers same functionality as most of the available database management systems but is 100 times more economical and easy to access Around 10 users in a network can access an MS Access database simultaneously It is easy to import data using MS Access database Database can be viewed in both data and design view
Disadvantages
MS Access is good to hold upto 2GB of data (can hold small databases) SQL for MS Access is not as robust as compared to other large database management systems like SQL Server or Oracle Queries, forms and reports are very slow to access as all information is saved in one single file Technical limit to access MS Access database is 255 concurrent users but real world limit is 10-80 users only depending upon the application.(Learnitanytime, 2015)
(Bright Hub, 2015)
Oracle Advantages
Oracle database can support large volumes of data and is capable of managing multiple databases using two phase commit protocol. It has the facility to support cursors. Each transaction that is executed is independent of each other. Follows ACID properties (Atomicity, Consistency, Isolation and Durability) which increases security of data. It has very good capacity for fault tolerance and in time backup and recovery system Oracle supports cursors, which enhances performance
(Erpgreat.com, 2015) Read more about Computer programming assignments help Disadvantages
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
4
It is not ideal if an organisation wants to use database to fullfill basic functionalities as it is very large and complex. (Ask, 2015) Oracle is most complex database management system thus it is very tough to manage the database with it.
This is just a part of whole assignment for complete data model assignment help click here to submit assignment Programming Assignments Help is the best assignment help provider in the United Kingdom. Our online assignment writing help UK is especially dedicated for the students studying in all UK colleges and universities. We offer the best quality Data Models assignment help to the students who are studying Computer Programming at under – graduate, post – graduate or research level.
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net