Completed

Normalizing Relations (Tables)

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 [url removed, login to view] 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 [url removed, login to view] conference is a venue for the discussion of open source issues and the development of open source technologies and [url removed, login to view] 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.

Keahlian: Pengembangan Database, Pemrograman Database, SQL

Lihat lebih lanjut: toner design, the need for business information presentation, that fish place, software for invitation design, software development company business model, software development college, open source sql, open source label design, office relationships, office furniture design ideas, new business plan for 2016, label new design ideas, label design ideas, invitation design software, information technology manager, i need a business development manager, hp ideas, free naming, fish business plan, expert business presentations

Tentang Pemberi kerja:
( 27 ulasan ) Hamilton, Canada

ID Proyek: #10070810

Diberikan kepada:

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 dalam 1 hari
(17 Ulasan)
3.8

17 freelancer menawar dengan rata-rata $60 untuk pekerjaan ini

eperfections

I am database expert and i will do this assignment.

$111 CAD dalam 2 hari
(102 Ulasan)
6.4
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 Lebih banyak

$30 CAD dalam 2 hari
(25 Ulasan)
4.9
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 Lebih banyak

$133 CAD dalam 4 hari
(40 Ulasan)
5.1
ashupathania

I have 5 years of experience in SQL development.

$40 CAD dalam 1 hari
(26 Ulasan)
4.8
shahzaib121

Hi Dear I have a lot experience in DataBases. I am Databases Certified from Oracle. I have done many work in Oracle, MYSQL, Access,Postgres Sql Server. I have done all kind of work front end, Back end, Integration Lebih banyak

$55 CAD dalam 3 hari
(18 Ulasan)
4.6
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 Lebih banyak

$100 CAD dalam 3 hari
(10 Ulasan)
4.2
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 Lebih banyak

$50 CAD dalam 1 hari
(18 Ulasan)
4.4
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 dalam 1 hari
(3 Ulasan)
3.6
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 Lebih banyak

$55 CAD dalam 1 hari
(4 Ulasan)
3.2
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 Lebih banyak

$72 CAD dalam 1 hari
(1 Ulasan)
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 Lebih banyak

$30 CAD dalam 3 hari
(2 Ulasan)
2.6
felipevitale

i have vasta experiencie 10+ Yeare in ORACLE PL SQL Development – design, stored procedures, queries, Web Forms/ Web Services. i can to Contribute to resolve incidents and tunnig querys, develop packages, proc Lebih banyak

$35 CAD dalam 2 hari
(0 Ulasan)
0.0
ccruzrodrguez

I have +20 years of experience in Information Technology , +15 of them at Database Administrator. You can see my profile in [login to view URL]

$122 CAD dalam 3 hari
(0 Ulasan)
0.0
$66 CAD dalam 1 hari
(0 Ulasan)
0.0
$20 CAD dalam 1 hari
(0 Ulasan)
0.0
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 Lebih banyak

$55 CAD dalam 2 hari
(0 Ulasan)
0.0