Question: When implementing a 1 1 relationship where should you place the
When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be mandatory or optional?
Answer to relevant QuestionsWhat is the most common design trap, and how does it occur?What are time-variant data, and how would you deal with such data from a database design point of view?The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC’s aircraft. Produce a data model segment that reflects the following business rules:All mechanics are FRC ...What is a surrogate key, and when should you use one?Using the INVOICE table structure shown in Table P6.3, do the following:a. Write the relational schema, draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies. You can ...
Post your question