Building your own er model editor

Assignment Help JAVA Programming
Reference no: EM13963063

Main Objectives:

ER-Diagram Editor and code generator. This would involve building our own ER model editor that would allow user to add their own SQL code generation. That is, insert how they want the ER model to generate SQL scripts for creating the database. The app could be either Java/JavaFX based or based in Javascript based (to run in a browser)

There are three important components of ER-model Editor: GUI, normalization process, generates SQL script and table.

There are existing normalization part in attachment, and also some examples in it, so need plug-in into this project. (It is an intellij project)

GUI(similar with draw.io would be great):

- User should be able to draw entity(parallelogram), weak entity, attributes of entity(ellipse), relationship between entity(line) in panel.
- User should be delete existing
- User should be able modify existing object from GUI

Normalization:
- Take user input from GUI and normalize the relationship between entities
- Pass normalized result to SQL script part.

SQL script:
- According the result get from normalization module, generates the corresponding entity, relationship... in SQL script format
- According to the SQL script, create SQL table

Equipment requirements:

- The ER-model Editor software should be able run in all windows system with Java environment installed.

Expected deliverables:
- GUI easy to use, and looks excellent
- Output correct normalized dependences
- Create correct table in SQL relational database
- Software not crash
- All features are implemented and can be tested

Attachment:- JavaFXNormalizer.zip

Reference no: EM13963063

Questions Cloud

Write about types of market efficiency : Select one of the following forum topics to research and write about- Efficient capital markets, Types of market efficiency and Behavioral finance and market efficiency
Write about dividend policy : Forum Topic Responses: One comprehensive forum topic is assigned weekly. Students are required to research their selected forum topic, Select one of the following forum topics to research and write about- Dividend policy
How much will this account be worth at that time : For the last 19 years, Mary has been depositing $500 in her savings account , which has earned 5% per year, compounded annually and is expected to continue paying that amount. Mary will make one more $500 deposit one year from today. If Mary close..
What is the pv of the cash flows : You own a natural gas pipeline that will generate a $2 million cash return over the coming year. What is the PV of the cash flows if the pipeline is scrapped after 20 years
Building your own er model editor : Take user input from GUI and normalize the relationship between entities - important components of ER-model Editor - ER-Diagram Editor and code generator. This would involve building our own ER model editor that would allow user to add their own SQL..
How long will you measure it to be if it flies past : What would be the difference between the time t measured by an observer moving at 30m/s and the proper time T0 for a proper time interval of 1 hour (3600 s)? The answer is small but nonzero. You will need to find an expression for the time differe..
Compare the net operating income figures that you computed : Compare the net operating income figures that you computed in requirements 2 and 3 to the break-even point that you computed in requirement 1. Which net operating income figures seem counterintuitive? Why?
Determine the concentration in the exiting : Determine the SO2 concentration in the exiting gas as a function of solvent flow rate from 25 to 175 mol/min and prepare a graph for our staff to use in operating this process
Problem regarding the nxn matrices : If P and Q are nxn matrices with PQ-QP = P, prove that (P^2)Q - Q(P^2) = 2(P^2) and (P^3)Q - Q(P^3) = 3(P^3)

Reviews

Write a Review

JAVA Programming Questions & Answers

  What is a java package and how is it used

What is a Java package and how is it used? What are synchronized methods and synchronized statements?

  Please write the code in java nbsprecursionimplement a

please write the code in java nbsprecursionimplement a subsetgenerator that generates all subsets of the characters of

  Implement avl tree

Implement AVL trees that allows both iterative traversal and recursive traversal.

  Create a 2-dimensional array for the volume of concrete

Your Company constructs concrete hemispherical domes that range in diameter from 40 to 90 feet and increments of 5 feet.

  Your taskbullthe auction system should allow the user to

your taskbullthe auction system should allow the user to participate in a number of items and for the user to be able

  Write java program to print strings given at command line

Write a program Average.java which just prints strings that it is given at command line, one per line. If nothing is given at command line, print "No arguments".

  Developing a java application

You have been requested to develop a Java application for the local library as part of an upgrade initiative. As in all libraries, this is a place where one can check out books

  Create an array of integers at random

create an array of integers at random with a range of 0 through 1000 in Java... any hints?

  Design an algorithm that creates the table c

Design an algorithm that creates the table C according to the above description and has time complexity Theta(m^2).In response give either pseudocode or the description of the steps of the algorithm, and justify the time complexity.

  Evaluate the total average of all the inputs

Once the user enters in the desired amount of inputs, they will then select the second button "Calculate".

  Using a linked implementation of graph write a method that

using a linked implementation of graph write a method that takes two nodes as input and returns true if joining an edge

  Write a c program that accepts a month and day

Write a C program that accepts a month and day (for example, June 14) from the keyboard as input. Store this information in a string called date

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