Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the following functionality:

1.  Insert a new user, make sure that every email can be registered at most once.

2.  Delete an existing user;

3.  Update an existing user by any attribute. Some easy GUI interfaces are expected for every functionality.

Posted Date: 3/20/2013 7:40:32 AM | Location : United States

Ask an Expert

Related Discussions:- Gui interfaces, Assignment Help, Ask Question on Gui interfaces, Get Answer, Expert's Help, Gui interfaces Discussions

Write discussion on Gui interfaces
Your posts are moderated

Write your message here..

Related Questions

BMIS 351, Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work... Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Use the relational algebra to formulate query, Consider the following datab... Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

Explain the use of constraints in functional model, Explain the use of cons... Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Using sql create a view rs for the relations r and s, Using SQL create a vi... Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

Basics of relational models, In the first unit of this block, you have been... In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you informat

What is a built-in, What is a Built-in A notation of identity is built-... What is a Built-in A notation of identity is built-into the data model or programming language and no user-supplied identifier is needed. This form of identity is used in objec

Types of locks, Types of Locks There are two necessary types of locks: ... Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc

Define join and outer join, Define Join and Outer Join and differentiate be... Define Join and Outer Join and differentiate between them.      Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition.  Oute

Write short notes on data ware housing, Write short notes on data ware hous... Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

Give detail description on transactions, Give detail description on Transac... Give detail description on Transactions. - Using transactions we can group all SQL commands into a single unit. - Transaction begins with some task and finishes only when a