Data Modeling and Business Rules
Réviser ces flashcardsGratuit · répétition espacée · iPhone, Android, Mac et web
Toutes les cartes
1
What is a data model?
A relatively simple, usually graphical representation of complex real-world data structures
2
What is the purpose of data models?
To facilitate interaction among designers, programmers, and end users, and organize data for various users
3
What are the major historical evolutions of data models?
Hierarchical, Network, Relational, and Entity-Relationship models
4
What is an entity in a data model?
Anything about which data are collected and stored, typically mapping to a table
5
What is an attribute in a data model?
A characteristic of an entity, usually mapping to a column
6
What is a relationship in a data model?
An association among entities
7
What are the three main relationship types?
One-to-many (1:M), Many-to-many (M:N or M:M), and One-to-one (1:1)
8
What is a constraint in a data model?
A restriction placed on the data
9
What are business rules?
Brief, precise, unambiguous descriptions of policies, procedures, or principles within an organization
10
What characteristics must business rules have?
They must be written, up to date, easy to understand, and widely disseminated
11
Where do business rules typically come from?
Managers, policy makers, department managers, documentation, and interviews with end users
12
How are business rules translated into a data model?
Nouns become entities, verbs become relationships, and relationships are bi-directional
Plus de flashcards : Informatique
health lawsInformatique · AnglaismichaComp Sci II MidtermInformatique · AnglaisEucalyptusWeek 8 - Input and Output ManagementInformatique · Anglais—Griffith—Computer Security: Requirements and Policies (ECS 153A)Informatique · AnglaisYashComputer Security (CSDS 344) Midterm 1Informatique · AnglaisSydneyNetworking: OSI Model LayersInformatiqueJmacComputer Architecture: Von Neumann, Harvard, and Flynn's TaxInformatique · AnglaisDiandreiCompTia Security + Non-Multiple ChoiceInformatique · AnglaisInfosecSamuraiSystems ImplementationInformatique · Anglais—Griffith—SQLInformatique · AnglaisMohamedWindows Command Prompt ModifiersInformatique · Anglaisun étudiant OutLearnCS325InformatiqueClement
Révise ces decks dans l’app
Gratuit sur iPhone, Android, Mac et le web. Ajoute n’importe quel deck à ton compte en un tap.
