Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
or

Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

INFS247Chapter7

terms and whatnot

QuestionAnswer
1st Database Development Activity Project Planning and Initiation
2nd Development Activity Conceptual Design (Requirement Collection and ER Modeling)
3rd Development Activity Logical Design (Relational Modeling)
4th Development Activity Implementation (Via DBMS)
5th Development Activity Use (via DBMS or Indirect) and Maintenance
Entity Person, place, object, event, or concept
Attribute Property or characteristic of an entity
Key Attribute An attribute that uniquely identifies individual instances of an entity
Relationship An association among the instances of entity types
Cardinality Constraints The number of instances of one entity that can or must be associated with each instance of another entity. Consists of: - Minimum Cardinality (Participation) - optional - mandatory - Maximum Cardinality - One - Many
Primary Key - Uniquely identifies a row in a relational table - Equivalent to the Key attribute in the ER model
Foreign Key - Used to implement relationships (one-to-one, one-to-many, many-to-many) in relational model - Depicted by the Referential Integrity Constraint: a line with an arrow pointing from the foreign key to its source.
Components of a DBMS - Data definition - Data manipulation - Application generation - Data administration
Data definition component allows user to create tables and relationships
Data manipulation allows users to create, read, update, and delete information in a database.
Application generation Allows users to create various interfaces to databases. Users can define report and form formats.
Data administration Allows DBA (Data Base Administrator) to maintain technical aspects of database systems (such as performance, security, etc.)
Created by: simonaa29
Popular Business sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards