logo

NIT1201 Introduction to Database Systems

   

Added on  2020-05-01

2 Pages413 Words66 Views
Question 1.Yes this data table is database.This is because, this table is a collection of logically related data that meets information need of an organization, which explains what database is. We can see different columns that are related to each other as per database explanation.Question 2.What are the functionalities of a DBMS?a)Input data into a database by loading values from a data file.b)Delete a data record from a table in the database.c)Login as an administrator role.d)Search for a customer’s purchase history.Question 3.Who are the users of a DBMS?a)Application Developersb)Physical database designersc)DBMS Operatorsd)Software package Developerse)Parametric end usersf)Database administratorsg)Database designersh)Data administratorsQuestion 4.Can you enumerate the advantages and disadvantages of using database approach?Advantages of Database approach1.Database approach helps control redundancy in systems.2.Database approach helps in restricting unauthorized access to database systems.3.Database approach helps in storing of structures and techniques for efficient querying.4.Database approach helps provide recovery of systems and backups in case of a risk.5.Database approach helps provide multiple user interfaces of systems.6.Database approach allows actions to be done on systems using given rules.7.Database approach helps impose integrity constraints to database systems.8.Database approach aids in complex relationships between data.9.Database approach helps increase productivity

End of preview

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

Related Documents
Lecture Notes in Database Management Systems
|41
|1736
|28

Database and Information Management - Assignment
|5
|1165
|18

Data Modelling & SQL Language: Assignment
|11
|1420
|93

Database Design and Implementation
|15
|3038
|164

Database Design and Implementation
|15
|3038
|167

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