Explain er model, Database Management System

Assignment Help:

Question 1 Explain ER model

Question 2 What are the characteristics of a computer provided information?

Question 3 What are facts and guidelines to be considered when selecting a character set?

Question 4 Explain

  • altering tables
  • Dropping table

Question 5 Write an SQL query to create the student table with the necessary columns and check whether that column allows null values.

Question 6 Create a student table with the following attributes Student name, student roll no, 5 different subjects. Write SQL query for the following conditions

  1. Add column to display the total marks of a particular student
  2. Add column display the Grade of the student >60 First > 40 & < 60 Second < 40 Fail
  3. Group all the students who got Fail grade

Related Discussions:- Explain er model

Define the wait for graph, Define the Wait for graph Ans: The wait-for-...

Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

Concurrency control, Give the two reasons for allowing concurrency

Give the two reasons for allowing concurrency

Attribute, a set of possible data value of an attribute is called??

a set of possible data value of an attribute is called??

Which data manipulation command combines the records, Which data manipulati...

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

What is a data warehouse, Problem 1 What is a Data Warehouse? Mention i...

Problem 1 What is a Data Warehouse? Mention its advantages 2 Explain the Top-Down and Bottom-up Data Warehouse development Methodologies 3 What is Data Transformation? Ex

Write short notes on schema diagram, Write short notes on Schema diagram. ...

Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears

Query to delete constraint from alter table, A constraint named less_than_2...

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Generalization and specialization, design a generalization specialization h...

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Assignment SQL Management Server 2012, Have database built but having probl...

Have database built but having problems with some questions that go with the database

Lock, intent locking

intent locking

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd