AFM241 Lecture Notes - Lecture 5: Database Theory, User Experience, Unique Key

• School: University of Waterloo
• Department: Accounting & Financial Management
• Course: AFM241
• Professor: Theophanis Stratopoulos

Document Summary

Applying our lessons learned to a start-up business. Guest speaker founder of bananny ( a taiwanese company) They are using that now and most comfortable with that. They designed their website and app depending on what nannies are used to using. Made signing up on our platform easy. Nannies don"t use email, so how can they log in to the account. User experience is heart of designing a product. Developing an app is time consuming and expensive. Asked them about technology: barriers to adoption are people"s willingness to use, create something that already exists and let people migrate to it, need to know what users like to experience. Foreign key: primary key you pull from another table. 1 to many relationships: 1 id can be repeated many times. Many to many relationships: product and orders. Database management systems: layering database to improve security.