INFO 340 Study Guide - Comprehensive Final Exam Guide - Unique Key, Relational Database, Database
Document Summary
Knowledge/understanding once you have enough information (learning) Data is the crux of competitive advantage; can take advantage of limited resources: e. g. , paying for convenience or price. Lose consistency with each update (again, not scalable) Gain efficiencies when we were able to manage large amounts of data. Post-wwii: originally organized data like a paper-based system on computers. When dealing with money, must be accurate and scalable. Has not changed much since the 1960s. Advantages: easy to understand (organized into objects that are related to each other) Interview clients/stakeholders understand who they are: know the business space its vernacular, who will use database, decisions that will be made. Create table tblgender (genderid integer identity(1,1) primary key not null, Create table tblplayer (playerid int identity(1,1) primary key not null, Genderid int foreign key references tblgender (genderid) null) Specialization vs generalization in database design (enhanced entity-relationship (eer) model)