+1 vote
138 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

Database design is defined as: "design the logical and physical structure of one or more databases to accommodate the information needs of the users in an organization for a defined set of applications". The design process roughly follows five steps:  

1. Planning and analysis

2. Conceptual design

3. Logical design

4. Physical design

5. Implementation

The data model is one part of the conceptual design process. The other, typically is the functional model. The data model focuses on what data should be stored in the database while the functional model deals with how the data is processed. To put this in the context of the relational database, the data model is used to design the relational tables.  

The functional model is used to design the queries which will access and perform operations on those tables.  

Related questions

+2 votes
1 answer 478 views
+2 votes
1 answer 913 views
+1 vote
1 answer 1.3k views
+1 vote
1 answer 68 views
+3 votes
1 answer 180 views
+1 vote
1 answer 29 views
+1 vote
1 answer 39 views
+1 vote
0 answers 11 views
+1 vote
1 answer 150 views
+1 vote
1 answer 113 views
+2 votes
1 answer 408 views
+2 votes
1 answer 754 views
+1 vote
1 answer 95 views
+1 vote
0 answers 12 views
+1 vote
1 answer 308 views
+2 votes
1 answer 881 views
+2 votes
1 answer 286 views
+1 vote
1 answer 152 views
+2 votes
1 answer 378 views
0 votes
1 answer 71 views
0 votes
1 answer 77 views
asked Sep 23 in Database Management Systems by (user.guest)
0 votes
1 answer 61 views
+2 votes
1 answer 502 views
+1 vote
1 answer 490 views
+1 vote
1 answer 178 views
+1 vote
1 answer 3.3k views
+1 vote
1 answer 498 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...