logo

Database Design and Implementation

Develop a database for AutoSeller, an online start-up company for car buyers and sellers, that will satisfy all their requirements.

15 Pages3038 Words164 Views
   

Added on  2023-04-21

About This Document

This document provides an overview of database design and implementation. It covers topics such as the difference between RDBMS and file-based systems, advantages and disadvantages of RDBMS, limitations of RDBMS, advantages and disadvantages of file-based systems, advantages and disadvantages of hierarchical, network and relational database models, strengths and weaknesses of top-down and bottom-up approaches, conceptual modeling, logical modeling, and SQL script.

Database Design and Implementation

Develop a database for AutoSeller, an online start-up company for car buyers and sellers, that will satisfy all their requirements.

   Added on 2023-04-21

ShareRelated Documents
Running head: DATABASE DESIGN AND IMPLEMENTATION
Database Design and Implementation
Name of the Student
Name of the University
Author’s note:
Database Design and Implementation_1
1DATABASE DESIGN AND IMPLEMENTATION
Table of Contents
Task 1: Understanding of database ................................................................................................. 2
Difference between RDBMS and File-Based System ................................................................ 2
Advantage of RDBMS ................................................................................................................ 2
Disadvantages of RDBMS .......................................................................................................... 3
Limitation of RDBMS ................................................................................................................ 3
Advantage of File-Based System ................................................................................................ 3
Disadvantage of File-Based System ........................................................................................... 3
Limitation of File-Based System ................................................................................................ 4
Advantages of Hierarchical, network and relational database models ....................................... 4
Disadvantage of Hierarchical, network and relational database models .................................... 5
Strength of top-down and bottom-up approaches ....................................................................... 6
Weakness of top-down and bottom-up approaches .................................................................... 6
Task 2: Conceptual Modelling ........................................................................................................ 7
Task 3: Logical Modelling .............................................................................................................. 7
Task 4: SQL Script ......................................................................................................................... 9
Bibliography: ................................................................................................................................ 13
Database Design and Implementation_2
2DATABASE DESIGN AND IMPLEMENTATION
Task 1: Understanding of database
Difference between RDBMS and File-Based System
File system is easy to use system which is required for storing files which requires
minimum security and constraints. While database management system is taken into account when
the security constraints are very much high. In file-based system, the redundancy of data is more
in comparison to RDBMS (Arulraj and Pavlo 2017). Data inconsistency is there is more in file
system in comparison to RDBMS. In file-based system, centralization is tough while it is easy in
RDBMS. In file management system, user can locate the physical address while in RDBMS user
is unaware of physical address. In the file management system, the overall security is considered
to be low while it is high in RDBMS(Poerner and Winkelmann 2017). File management system
aims to store unstructured data like isolated data and entries or files. RDBMS aims to store
structured data which comes up with proper constraints and interrelation.
Advantage of RDBMS
There are certain number of advantages of RDBMS like
Control of Redundancy: In file-based system, each of the application comes up with own
private files which cannot be shared between the application (Elmasri and Navathe 2017). By
having centralized database issues of storage waste can be avoided.
Integrity can be enforced: Integrity of data in the database is all about accuracy like
inaccurate data which can be stored in the database.
Inconsistency can be avoided: The same kind of data is duplicated and changed at the
given site which cannot be propagated to another site.
Database Design and Implementation_3
3DATABASE DESIGN AND IMPLEMENTATION
Disadvantages of RDBMS
There are disadvantages of RDBMS like
Complexity: A good RDBMS makes use DBMS which is considered to be an extremely
piece of software.
Performance: File-based systems are generally written for some specific application like
invoicing so that the overall performance is good.
Cost of DBMS: There is huge amount of cost involved in DBMS which totally depends
on environment and overall functionality.
Limitation of RDBMS
There are certain number of limitation of RDBMS like
RDBMS aims to provide definite processing of data.
Huge amount of capital investment is required in hardware, software and training.
Advantage of File-Based System
There are certain advantages of File-based system like
Back of data
Retrieval of data.
Remote access.
Sharing.
Disadvantage of File-Based System
There are certain disadvantages of file-based system like
Database Design and Implementation_4

End of preview

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

Related Documents
Database Design and Implementation
|15
|3038
|167

Database Design and Implementation
|20
|3051
|345

Data Modelling & SQL Language
|23
|3728
|185

Data Modelling and SQL Language
|16
|2546
|97

Data Modeling & SQL Language: Assignment
|22
|2594
|138

Data Modelling SQL Language Tasks 2022
|11
|1864
|21