The process of identifying the entities, their attributes and the relationships between entities. Data modelling tools consist of data dictionaries, schematice diagrams and normalisation, data dictionaries help to validate data that is entered into the database by forcing any data entered to...
participants directly carry out the information process of an system e.g. a database administrator while the users just use the output and generally benefit from the system
hmm okay but can you expand on
Data security - easier to achieve, levels of access
Data quantity - works efficiently with large amounts of data
also i know what primary/composite/secondary/foreign keys are but what is a key field and is an index key the same thing as a primary key
ermm..can anyone list all the advantages of a normalised relational database versus a flat file database
i've got
-much more flexible in design
-reduction in redundant data
-takes up less space as redundant information is reduced
-greater overall database organisation
-easier to...
heinman is good enough...people i know have gotten 90 + purely with heinman
i think its how you apply yourself and renember basic points as no one would memorise the whole book. None of the questions really tell you to spit out a definition mostly they make you draw diagrams and apply things to...
uhh...anyone here use flashcards to rote learn all the definitions etc. ?
because my pile is now >10cm high and i have no idea how to study for trials or hsc .___.