Solution-How you can change the above table into two-nf

How you can change the above table into two-nf

Assignment Help Database Management System

Reference no: EM131479850

Assignment

Question One

Suppose you want to store the following information:

Student_id	Course	Mark
111	Maths	78
111	Physics	90
222	Biology	89
333	Physics	60
333	Chemistry	75

1.a Is this table in first normal form? Why or Why Not?

1.b Why it is not in 2NF? How you can change the above table into 2NF.

Question Two

2. Using the following relationsto write SQL statement that follows:

Product (product_name, price, category, company_name)
Company (company_name, stockPrice, country)

a- Find all products produced by USA and have a price greater than 500.

b- Find the Categories that a product might belong to. Make sure that the category is not repeated and it is listed in ascending order.

c- delete all products with that belong to SONY company.

Question Three

3.a List the three design goals for relational databases, and explain why each is desirable.

3.b What is the result of an arithmetic expression involving nulls, for instance, what 7 + null would return?

Reference no: EM131479850

Questions Cloud

Benefits of and barriers to medical tourism : Identify benefits of and barriers to medical tourism. Reflect on reasons consumers may or may not seek medical care outside of their home country.

Find differences between the gdp and gni rankings : Below is a partial table of the OECD's 2004 ranking of member countries based on their GDP per capita. Compute the ratio of GNI to GDP in each case.

Global marketing strategy-international marketing strategy : determine if you would employ a global marketing strategy or an international marketing strategy.

The physical access controls and logical access controls : Research a specific lapse in professional ethics by an IT professional in the last five (5) years. Be prepared to discuss.

How you can change the above table into two-nf : Why it is not in 2NF? How you can change above table into 2NF. What is result of arithmetic expression involving nulls for instance, what 7 + null would return?

Manufacturers high-end custom leather bags : Larry Ellison starts a company that manufacturers high-end custom leather bags.

Find the gross national income : Using this expression, show that in a closed economy, gross domestic product (GDP), gross national income (GNI), and gross national expenditures (GNE).

Analyze the input data for the inspection times : Process Modeling and Analysis in an Assembly Factory - Analyze the input data for the inspection times and fit a suitable distribution.

Describe the best practices for mitigating vulnerabilities : For Web applications, describe the best practices for mitigating vulnerabilities in order to prevent buffer overflow (BO) attacks or SQL Injections (SQI).

User Account

All Pages

How you can change the above table into two-nf

Reference no: EM131479850

Reference no: EM131479850

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT