Build tables including primary and foreign keys,
For the second part of this project you will take the business information, normalized data in 3NF and finalize the database design process: You should incorporate the feedback you received on Project Part 1 to improve your database design. Submission of Project Part 2 MUST include all of the following items:
- Complete MS Visio Entity-Relationship Diagram (ERD) for the database design. Include all maximum and minimum cardinalities on your diagram. Be sure to identify all primary and foreign key fields. The ERD CANNOT be hand-drawn; you must use MS Visio via the XenDesktop to diagram.
- You must include all business rules that will affect your database design. Business rules are constraints, or restrictions that limit how you develop your database. For example, in a sales-oriented database, quantities purchased cannot be negative. Identify all business rules that you believe will affect your database design. Also, decipher the relationships in your ER diagram in written form.
- DBMS - put together database structure using the normalized data found in your 3NF dependency diagrams and your Visio ER diagram.
i. Build tables including primary and foreign keys, data fields with specific data types, and notes in each field in design view explaining the purpose of the data. For instance, you have a table named EMPLOYEES, one field is named EMPLOYEE_ID, its data type is number, and its description is primary key unique number given to each new employee.
ii. Add at least five records to each table using the datasheet view.
iii. Create relationships between tables. Remember when creating a 1:M relationship between two tables you need to enter the primary key field of the parent into the child table as a foreign key field. If you have a M:N relationship, you need to help with linking table containing a composite primary key field with two 1:M relationships connecting to it.
Â
i need help with thsi project turning my uploaded assignment into whats required above.
Attachments:
Answers
Status NEW
Posted 23 Nov 2017 12:11 PM
My Price 10.00
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly
Not Rated(0)