Prepare for your exams
Get points
Guidelines and tips
Sell on Docsity
Docsity AI

Prepare for your exams

Study with the several resources on Docsity

Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips

Sell on Docsity

Docsity AI

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents

20 Points

For each uploaded document

Answer questions

5 Points

For each given answer (max 1 per day)

All the ways to get free points

Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database Design Methodology: Conceptual, Logical, and Physical Design, Lecture notes of Design

Design

The process of designing a database, from the conceptual stage of constructing a model of the enterprise's data, to the logical stage of modeling the data based on a specific data model, and the physical stage of producing a description of the database implementation. examples of ER diagrams for the Staff user views of DreamHome, with primary keys added and with specialization/generalization.

Typology: Lecture notes

2021/2022

Uploaded on 09/12/2022

kataelin 🇬🇧

4.7

(9)

221 documents

1 / 10

This page cannot be seen from the preview

Don't miss anything!

Conceptual Databases Design

Partial preview of the text

Download Database Design Methodology: Conceptual, Logical, and Physical Design and more Lecture notes Design in PDF only on Docsity!

Conceptual Databases Design

Design Methodology

◆ A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design.

Conceptual Database Design

◆ The process of constructing a model of the data used in an enterprise, independent of all physical considerations.

Logical Database Design

◆ The process of constructing a model of the data based on a specific data model (e.g. relational), but independent of a particular DBMS and other physical considerations.

Build Conceptual Data

◆ To build a conceptual data model of the data requirements of the enterprise.

Identify entity types
Identify relationship types between entities
Identify attributes associated with entity or relationship types
Determine candidate, primary, and alternate key attributes
Consider use of enhanced modeling concepts, such as specialization / generalization (optional step)
Review conceptual data model with user

First-cut ER diagram for Staff user views

of DreamHome

Revised ER diagram for Staff user views of DreamHome with specialization / generalization