Normalizing Relations (Tables)

Suoritettu Julkaistu Mar 28, 2016 Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

Assignment: Normalizing relations

PROBLEM 1: THE FOUNDIT COMPANY DATABASE

To keep track of office furniture, computers, printers, and so on, the FOUNDIT Company uses the table structure shown in the following Table.

Attribute Name Sample Value Sample Value Sample Value

ITEM_ID 231134-678 342245-225 254668-449

ITEM_LABEL HP DeskJet 895Cse HP Toner DT Scanner

ROOM_NUMBER 325 325 123

BLDG_CODE NTC NTC CSF

BLDG_NAME Nottooclear Nottoclear Canseefar

BLDG_MANAGER I. B. Rightonit I. B. Rightonit May B. Next

a. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies.

b. Write the relational schemas and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.

c. Draw the Crow’s Foot ERD.

PROBLEM 2:DINNER CLUB DATABASE

Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to keep track of who attends the dinners, and so on.

• Each dinner serves many members, and each member may attend many dinners.

• A member receives many invitations, and each invitation is mailed to many members.

• A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn. Or the dinner may be composed of a fish entree, a baked potato, and string beans.

• A member may attend many dinners, and each dinner may be attended by many members.

Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in the following table:

a. Given the table structure illustrated in the Table above, write its relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. (Hint: This structure uses a composite primary key.) Note that DIN_CODE in Figure P6.7a does not determine DIN_ATTEND; just because a dinner is offered does not mean that it is attended.

b. Remove all partial dependencies, draw the new dependency diagrams, and identify the normal forms for each table structure you created.

c. Remove all transitive dependencies, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created.

c. Draw the Crow’s Foot ERD.

Note that because the dependency diagrams cannot show the nature of the relationships (1:1, 1:M, M:N), the ER Diagrams remain crucial to the design effort.

PROBLEM 3: FSOSS CONFERENCE SCHEDULE DATABASE

FSOSS is the Free Software and Open Source Symposium hosted by Seneca College’s Centre for Development of Open [login to view URL] conference is a venue for the discussion of open source issues and the development of open source technologies and [login to view URL] schedule of the conference in 2015 has spanned over 2 days where multiple sessions run in different rooms each day. During a session, a list of presentations take place in order.

a. Design the relational database model to support the conference schedule and bring the tables to 3NF. You can start with a table structure that contains all attributes you can derive from the conference schedule. Include session_number and presentation_order among the attributes of the table.

b. Draw the Crow’s Foot ERD.

c. Imagine we need to add the attendees’ information and their registration date in the database. Also we would like to keep track of who attends each presentation. Modify your ERD to include the previously mentioned requirements.

Tietokantakehitys Tietokantaohjelmointi SQL

Projektin tunnus: #10070810

Tietoa projektista

16 ehdotusta Etäprojekti Aktiivinen Mar 29, 2016

Myönnetty käyttäjälle:

rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

$32 CAD 1 päivässä
(21 Arvostelua)
4.1

16 freelanceria on tarjonnut keskimäärin $56 tähän työhön

eperfections

I am database expert and i will do this assignment.

$111 CAD 2 päivässä
(102 arvostelua)
6.5
vw7209238vw

Hi, I can give you the ERD diagrams for you. I am expert creating 3FN diagrams. because my work is to design, create, program populate and manage databases. You will have to develop all the formal part of your pr Lisää

$30 CAD 2 päivässä
(52 arvostelua)
5.8
alenrex8

I have +2 year experience in Database. I an expert in normalization and ERD. I have done Crow's-foot diagram of the EDR in many project.

$10 CAD 1 päivässä
(5 arvostelua)
5.4
point5nyble

Ashish Seth Proposal Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Rep Lisää

$133 CAD 4 päivässä
(45 arvostelua)
5.2
ashupathania

I have 5 years of experience in SQL development.

$40 CAD 1 päivässä
(28 arvostelua)
4.8
Softeria

I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server 2008 and Oracle10g. I can Develop you ER Diagrams (Crows foot notation), EERD, I can conve Lisää

$100 CAD 3 päivässä
(16 arvostelua)
4.9
nyarOnyari

Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already desig Lisää

$55 CAD 1 päivässä
(19 arvostelua)
4.4
mdakteruzzaman

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here Lisää

$50 CAD 1 päivässä
(18 arvostelua)
4.6
BitLabs

Hello, I have gone through your outsourced requirements "Normalizing Relations (Tables)" and have analyzed that I have right credentials and Skills required Database Development, Database Programming, SQL to execu Lisää

$72 CAD 1 päivässä
(1 arvostelu)
3.1
handsum

As per you requirement we have a team that will definitely provide best solution to you. We do fair code with reasonable price and client satisfaction is our Responsibility. Personally we have three + years experienc Lisää

$30 CAD 3 päivässä
(2 arvostelua)
2.6
irfanahmad697

Respected sir, This letter is to express my interest in your posting for an experienced Database Administrator or Manager IT. As a certified Oracle & Microsoft Database Administrator with a Master’s degree in Manage Lisää

$55 CAD 2 päivässä
(0 arvostelua)
0.0