Details of this Paper

Basic Database Design

Description

solution


Question

Appendix;http://i.imgur.com/kb6vFPU.png.;http://i.imgur.com/uq0tiB5.png.;Using the information pictured in the links above:.;1. Explain what the relevant entries are and how you would assign attributes to them.;2. Explain what the primary key would be for each entity;3. Explain to me how you would establish relationships and relationship rules between entities.;4. Produce an Entity-Relationship Model to demonstrate the relationship.;5. Add foreign key/s to the relevant entity/entities to enable the relationship to be established....;The requirements for the work to be a pass;Candidates will need to provide evidence to demonstrate their Knowledge and/or Skills by showing that they can: extract key information needs from source documents and produce design notes detailing relevant data to be stored in a relational database. Design notes will include;Entity Relational Modelling approach to demonstrate relationships between appropriate tables/entities;use of database notation to define table/entity content including primary and foreign keys;set referential integrity between tables and justification of cascade update and cascade delete;The resulting relational database should comprise three tables;The tables should include;valid data field names;data types of one occurrence of date/time, number, text and currency;customised field sizes appropriate to field content;primary and foreign keys;referential integrity rules applied

 

Paper#72719 | Written in 18-Jul-2015

Price : $27
SiteLock