D. Answer the following questions.
1. What is a DBMS? Discuss its functions.
2. Suggest two ways to create a database.
3. Discuss two ways of creating tables in MS Access 2010.
4. What are data types? Name some commonly used data types in MS Access 2010.
5. What is the importance of the primary key?
Answers
Answer:
Ans - 1 - A database management system is a software tool that makes it possible to organize data in a database it is often referred to by its acronym, DBMS. The function of a DBMS include concurrency, security , backup and recovery , integrity and data descriptions.
Ans - 2 - The two suggest ways to create a database are :
1 - open microsoft Access 2013 , and tab file - New. Aur click blank desktop database directly in Access interface .
2 - A new dialog appears with new database default name and location .
3 - click create button at least .
Ans - 3 - ( 1 ) - Click file > New , and then select blank desktop database .
( 2 ) - in the file name box , type a file name for the new database .
( 3 ) - to browse to a different location and save the database , click the folder icon
Ans - 4 - when creating table in Access , you need to select a data type for each column of data. the short text data type is a popular choice since it lets you enter almost any characters. However careful selection of data type can help you take advantage of more access future and improves the accuracy of the information you ' re storing. the table below gives an overview of the data types available in Access desktop databases . for information about data types in Access for a comprehensive list for all the various field properties available for the various data
Ans - 5 - A primary key ensures that data is unique in one column , but the foreign key is what makes , the data stay consistent and integral .
Answer:
1.Database Management System.
A database management system is a software tool that makes it possible to organize data in a database.
The functions of a DBMS include concurrency, security, backup and recovery, integrity and data descriptions.
2. In three different ways we can create a database.
A blank database.
Create a database by using template.
Create a database without using template.
3.Create Tables in Access Using “Design View”: Instructions
To create tables in Access using “Design View,” click the “Create” tab in the Ribbon.
Then click the “Table Design” button in the “Tables” group.
A new table then appears in the tabbed documents area.
Type the name of a field into the “Field Name” column.
4.A data type or simply type is an attribute of data which tells the compiler or interpreter how the programmer intends to use the data.
Commonly used data types in MS Access 2010 are :-
o Rich Text
o Lookup & Relationship
o Attachment
o Hyperlink
o Calculated Field
o Paste as Fields
5.In database design, a primary key is important because it serves as a unique identifier for a row of data in a database table. A primary key makes it convenient for a user to add, sort, modify or delete data in a database.