Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Model  to  Relational  Design  

/in /by

Phase  2  of  your  Personal  Collection  Database  Application

Mapping  from  E/R  Model  to  Relational  Design

Project  Description

The  course  project  will  be  spread  over  five  phases  over  the  rest  of  the  semester.

Due  date:   Sunday  April  7,  2019.

The  weight  of  this  project  component  is  10%  of  the  course  grade.

Please  submit  one  “pdf”  document  that  includes  the  following:

Entity-­‐Relationship  to  Relational  Schema:

(a) A  copy  of  your  updated  E/R  Data  Model  from  Phase#1  of  your  PC-­‐DBA.   Please  use  MySQL  Workbench  or  a  similar  software  system  to  generate  your  updated  diagram.   Hand-­‐drawn   diagrams   will   not   be   accepted   at   this   point.   The   course   material   on   Canvas   includes  several  tutorial  videos  about  the  MySQL  Workbench.

(b) Use  the  methods  for  transforming  an  E/R  diagram  to  Database  Relations  described  in  the  text   or   the   supplementary   lecture   notes   and   videos   posted   on   the   course’s   Canvas   website,   to   produce  a  set  of  relations  from  your  E/R  Data  Model.  Specify  your  relational  schema  using  the   notation  described  in  these  resources,  and  be  sure  to  indicate  key  attributes.

(c) For  each  Database  Relation,  add  your  comments  to  respond  to  the  following  question:

Are  there  any  flaws  in  the  relational  database  schema  you  get  from  part  (b)  above?

Normalization:

1. Are   there   any   opportunities   to   combine   relations   without   introducing   redundancy?   If   so,   indicate  which,  and  if  not,  tell  that  there  are  none.

2. Are  there  any  examples  relation  schemas  that  violate  the  Third  Normal  Form  (3NF)  or  Boyce-­‐ Codd   Normal   Form   (BCNF)?   If   so,   do   you  want   to   decompose   them?   Please   note   that   in   the   Design  phase,  you  may  knowingly  decide  to  violate  3NF,  BCNF  or  4NF  when  you  prefer  to  avoid   decomposition   of   a   big   relation   R,   because   you   anticipate   frequent   queries   on   R   and   if   R   is   decomposed  into  R1  and  R2,  then  that  will  lead  to  frequent  expensive  joins  of  R1  and  R2.

3. For  each  opportunity  to  combine  or  decompose  relations,  decide  whether  or  not  to  do  so,  and   explain   your   reasoning   briefly   (e.g.,   tell   what   queries   you   expect   will   be   typical   for   your   database,  and  tell  how  the  design  you  pick  facilitates  them).

4. Is  there  anything  you  still  don’t  like  about  the  schema  (e.g.,  attribute  names,  relation  structure,   duplicated  information,  etc.)?  If  so,  modify  the  relational  schema  to  something  you  prefer.

5. You  will  be  working  with  this  schema  quite  a  bit,  so  it’s  worth  spending  some  time  to  make  sure   you’re  happy  with  it.

☛ Please   submit   a   pdf   document   that   includes   your  E/R  Diagram  and   your   response   to   the   above   issues.

 

“Is this question part of your assignment? We Can Help!”

Model  to  Relational  Design   was first posted on September 3, 2019 at 10:05 am.
©2019 "Classroom Essays". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at Academicheroes.com

Source link

 

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

Model  to  Relational  Design   was first posted on September 3, 2019 at 10:06 am.
©2019 "Academicheroes.com". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at admin@Academicheroes.com.com

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"