Question
Hi, Could you please help me with the following: Create Database Design You now are going to transform your conceptual data model into a database
Hi,
Could you please help me with the following:
|
Create Database Design
You now are going to transform your conceptual data model into a database design. In most cases, an entity would be transformed into a table. Each non-identifying attribute would be turned into a column for that table. Each identifying attribute will turn into a column for the table if that identifying attribute doesnt come from the tables parent. An identifying attribute will be omitted from the table if that identifying attributes comes from the tables parent.
In other words the SKILL table doesnt have FirstName, LastName columns and the PURCHASE table doesnt have FirstName, LastName, Product columns.
Transform each entity into a table and place it in your database design diagram. In each table name include your initials of your student number. Example - CUSTOMER_BC. Identifying attributes taken from a parent are never fields in the table.
The Addresses attribute cannot be represented in the EMPLOYEE or CUSTOMER table. Create a separate ADDRESS table with the columns AddressID, Street, City, Province, Postal. Make EMPLOYEE and CUSTOMER parents of ADDRESS.
Create the same parent-child relationships in your database design that you see in your data model. Make sure you have Mandatory selected when creating your relationship. This will help with trouble shooting.
Confirm you did not duplicate the same column in two different tables
The SKILL table will have duplicated SkillName values. To remove duplication, add a SKILL_TYPE table with columns SkillTypeID and SkillTypeName. Remove SkillName in the SKILL table. Make SKILL_TYPE the parent of SKILL
Confirm all tables and columns follow proper naming standards. Tables are in UPPER_CASE and fields are in ProperCase.
Confirm all foreign key columns have the form Confirm all constraint names are under 30 characters to avoid compile errors There are 3 Steps involved in it See step-by-step solutions with expert insights and AI powered tools for academic success Get the answers you need in no time with our AI-driven, step-by-step assistance
Authors: Vivek Mishra
1st Edition
1484201426, 9781484201428 |
