index - Frequently Asked Questions Getting Started Database...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Getting Started Database Concepts Visio SQL Server SQL DDL Assignment One (Visio Basics) Assignment Two (DB Design) Assignment Three (Normalization) Assignment Four (DDL) Getting Started Do I need to take MIS 304 before MIS 325? Can I use a laptop during your lectures? How can I find out about MIS jobs, internships and scholarships? Are we responsible for the FYIs? How about the FAQs? Are we responsible for them? What is the policy on late homeworks? I forgot my Grade ID. Can you reset it so I can check my grades? I don't have an account to use the computers in the McCombs' labs. How do I get one? Database Concepts What is the difference between a primary and foreign key? Should every table have a primary key? Should every table have a foreign key? Should every foreign key have a primary key? Should every primary key have a foreign key? Can a table have more than one primary key? Can a table have more than one foreign key? Can a field be a primary and a foreign key at the same time? Can a child's foreign key have a different name than the parent's primary key? What is a composite key? What is a secondary index? How are secondary indices stored? What is referential integrity? What is the difference between 1:1, 1:N and M:N relationships? How are 1:1 relationships stored? How are 1:N relationships stored? How are M:N relationships stored? What do the records actually look like in a bridge table? Should I use a composite primary key or simple primary key in a bridge table? Can a bridge table be related to only one table? Can a bridge table be related to more than two tables? Can a bridge table be used to represent a 1:N relationship or is it only used for M:N relationships? What is an optional relationship? What is a unary relationship? The unary relationship in the previous FAQ was shown as optional in BOTH directions. Is that a
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 5

index - Frequently Asked Questions Getting Started Database...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online