Question
Write the steps to design a database.
✓
Answer
Steps to Design a Database
There are various steps to design a database which are as follows:
There are various steps to design a database which are as follows:
- Step 1 Determine the purpose of your database The first step of designing a database is to determine the purpose and mechanism to design and use it.
- Step 2 Determine the tables Tables are one of the most important elements of a database, consist of rows and columns. To create a well-defined database, you have to keep some conditions which are as follows:
- A table should not contain duplicate information.
- Each table should contain information about one subject.
e.g. One table is used to contain the personal information of the students and the other is used to contain the marks scored by the student.
- Step 3 Determine the fields After creating a table, you need to decide the type and number of fields required for the tables in your database. Each field in a table contains individual facts about the table’s subject.
e.g. A customer table may include company name, address, city, state and phone number fields. - Step 4 Identify the primary key in a table From the fields of table, you need to identify a primary key which uniquely identifies each individual record of the table. The primary key helps you to reduce data duplication in the table.
- Step 5 Determine the relationship between tables In this step, you need to determine relationship between two or more tables in your database. You can set-up a relationship between tables on the basis of common field between them. Establishing a relationship allows you to fetch any information from both the tables.
- Step 6 Refine the design After you have designed the tables, fields and relationships, its time to study the design and detect any faults that might remain.
- Step 7 Enter data and create other database objects When you are satisfied that the database structure meets the goals you needed, add all your existing data to the tables.
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Write the difference between open source code and software license.
List some advantages and disadvantages of an E-mail.
Write short notes on the following terms:
- Information retrieval
- E-banking
- Online shopping
- E-reservation
- E-groups
Write the HTML code to generate the following output:
Note the following points while generating the webpage:
→ Link colour is green, active link colour is blue and visited link colour is red.
→ Title of the page is "eat healthy live healthy".
→ Heading of the page is maroon.
→ Image used is "Restaurant.jpg".
→ Caption of table is blue.
→ Table border is blue and of size 2.
→ The 4 links are one.html, two.html, three.html and four.html.
→ The email id for contact us is abc@xyz.com.
Note the following points while generating the webpage:
→ Link colour is green, active link colour is blue and visited link colour is red.
→ Title of the page is "eat healthy live healthy".
→ Heading of the page is maroon.
→ Image used is "Restaurant.jpg".
→ Caption of table is blue.
→ Table border is blue and of size 2.
→ The 4 links are one.html, two.html, three.html and four.html.
→ The email id for contact us is abc@xyz.com.
Write the code to generate the following web page:
Special Notes:
a. Title of the page is "Application Form".
b. Background color of the page is silver.
c. Font used in heading is Times New Roman and color is Maroon.
d. All the form elements should be displayed within ordered list format.
e. Form should have one input box for name, one radio button for gender, one list box for educational qualification having graduate, post graduate, MCA, MBA and Others as options.
f. Form should have one textarea for qualification and experience details.
g. Form should have three checkboxes for hobbies such as Reading, Sports and Internet surfing.
h. Form should have two buttons Submit and Cancel to submit or cancel the form.
Special Notes:
a. Title of the page is "Application Form".
b. Background color of the page is silver.
c. Font used in heading is Times New Roman and color is Maroon.
d. All the form elements should be displayed within ordered list format.
e. Form should have one input box for name, one radio button for gender, one list box for educational qualification having graduate, post graduate, MCA, MBA and Others as options.
f. Form should have one textarea for qualification and experience details.
g. Form should have three checkboxes for hobbies such as Reading, Sports and Internet surfing.
h. Form should have two buttons Submit and Cancel to submit or cancel the form.
What do you mean by e-Group and its advantages.
Write the HTML code to design a website about your favorite Pastime with the following properties:
a. Title of the page is "WEBSITE".
b. Insert an appropriate image as a background of the web pages.
c. The heading of the page should be in BLUE color and style TIMES NEW ROMAN. It should be BOLD and LEFT aligned.
d. The first page should have the information in paragraphs each of which is in diffindows and alignment.
a. Title of the page is "WEBSITE".
b. Insert an appropriate image as a background of the web pages.
c. The heading of the page should be in BLUE color and style TIMES NEW ROMAN. It should be BOLD and LEFT aligned.
d. The first page should have the information in paragraphs each of which is in diffindows and alignment.
Write an HTML code to display the body text that appears 50 pixels away from the top edge of the web page and 55 pixels away from the left edge of the web page.
Distinguish between data and information.
Read the following paragraph. Find six network and communication related abbreviations and give their expanded form alongwith a single-line definition of each of them.
The RBI is planning to expand its connectivity with all major banks of India. The plan includes providing TCP connectivity through HTTP for easy access points and seeks help from some ISPs to join hands in this venture.
Also, there is a plan to set-up IIS and SMTP servers. Some banks will go for ADSL line while others will use leased line connectivity to access these services.
The RBI is also taking help of IIT professors in this venture.
The RBI is planning to expand its connectivity with all major banks of India. The plan includes providing TCP connectivity through HTTP for easy access points and seeks help from some ISPs to join hands in this venture.
Also, there is a plan to set-up IIS and SMTP servers. Some banks will go for ADSL line while others will use leased line connectivity to access these services.
The RBI is also taking help of IIT professors in this venture.