Write definitions using your own words for the first 20 Key Terms on page 218 (C
ID: 3591124 • Letter: W
Question
Write definitions using your own words for the first 20 Key Terms on page 218 (Concepts of Database Management 8th Edition) at the end of Chapter 6. Don't just copy and paste the definition from the book! Please take your time and write it as you write your own assignment that you want 100 grades on it! The definition must be related to the same chapter in the book NOT GENERAL DEFINITION. Do it correctly or leave it to please! Hand writes/Picture is Not working, Please answer in a way that I can copy and paste it easily, and don't miss any key term. Thanks!
Key Terms
artificial key
bottom-up design method
cardinality
category
complete category
composite entity
cumulative design
Database Design Language (DBDL)
dependent entity
entity-relationship (E-R) model
entity subtype
existence dependency
IDEF1X
identifying relationship
incomplete category
independent entity
information-level design
intelligent key
logical key
mandatory role
Explanation / Answer
artificial key
An artificial key (sometimes called a surrogate) is one that was created specifically to be the unique identifier of a row. Identity columns are the most common form of artificial keys
bottom-up design method
Bottom-Up Design method goals for a product are first outlined, then assembly of a product is done on a system by system basis.
Cardinality
The number of elements in a set or other grouping, as a property of that grouping.
Category
There are 4 categories: High-end OLTP (OnLine Transaction Processing) relational DBMS, Specialty data warehouse DBMS, Mid-range relational database management systems, Embedded relational database management systems.
complete category
a complete category is a category in which all small limits exist. That is, a category C is complete if every diagram F : J C where J is small has a limit in C.
composite entity
A composite entity is a thing composed of other things.
cumulative design
Technique of database design in which the system is built and then enhanced cumulatively
Database Design Language (DBDL)
DBDL is a language used for producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a datadefinition language, which can then be used to create a database.
dependent entity
For dependent entities, the foreign key must be a part of the primary key of the childentity (above the line) in order to uniquely define each entity.
entity-relationship (E-R) model
An entity-relationship model (ERM) is a theoretical and conceptual way of showing data relationships in software development. ERM is a database modelingtechnique that generates an abstract diagram or visual representation of a system's data that can be helpful in designing a relational database.
entity subtype
Subtypeis where one entity (the subtype) inherits the attributes of another entity (the supertype).
existence dependency
Existence dependency means that an instance of one entity cannot exist without the existence of some other related entity.
IDEF1X
Integration DEFinition for information modeling (IDEF1X) is a data modeling language for the development of semantic data models. IDEF1X is used to produce a graphical information model which represents the structure and semantics of information within an environment or system.
identifying relationship
An identifying relationship is when the existence of a row in a child table depends on a row in a parent table.
incomplete category
Incomplete category is an entity that cannot be uniquely identified by its attributes alone.
independent entity
Entities that do not depend on any other entity in the model for identification are called independent entities.
information-level design
This involves Defining user views and explain their function, defining Database Design Language (DBDL) and use it to document database designs. Create an entity-relationship (E-R) diagram to visually represent a database design. Present a method for database design at the information level and view examples illustrating this method.
intelligent key
An intelligent key is a code made up of sections, where one or more parts may have meaning. An intelligent key "code" uniquely identifies an object such as an account or a part or a job.
logical key
Logical keys are part of the database design, defining the relationships between tables: primary keys, foreign keys, and common keys.
mandatory role
Manadatory role is a role which must be assigned to an user in the system and is optional.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.