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

  Write a java program to perform matrix multiplication

Write a java program to perform matrix multiplication - Your code will need to be able to read in these files, place the contents of each file into separate two-dimensional arrays and then perform the needed multiplication and place the output of t..

  Typical industrial engineering problem

A company manufactures two products, A and B. Product A can be sold for $145 per unit and B for $75 per unit. Management requires that at least 1850 units be manufactured each month.

  Write down java program for furniture company

Write down a Java program for the furniture company. Ask user to select P for Pine, O for Oak or M for Mahogany. Illustrate price of table manufactured with chosen wood.

  Find method of the class is passed each of the targets

How many calls to the recFind method of the ArraySortedList3 class are made when the find method of the class is passed each of the targets?

  Create a package called people

Create a second package called ‘task01'. Within this package provide classes which perform the following tasks.

  Assignment in python

You will complete this assignment in Python 3.x. Make sure you have downloaded the software and it is installed correctly. You will download it from this site: https://www.python.org/downloads/.

  Create a new project in your ide named animalinfo

Create a new project in your IDE named "AnimalInfo." Create a class called "AnimalInfo" as the main class for the program.

  Write a bag class with a generic type

Write a Bag class with a generic type. Write a class such as item that has a name and price - Add objects of item to the bag and find the average and the total of the price of all items in the bag.

  Method that accepts a string object

Word Counter Write a method that accepts a String object as an argument and returns the number of words it contains. For instance, if the argument is "Four score and seven years ago" the method should return the number

  Write a java program that accepts a positive long integer

Write a Java program that accepts a positive long integer between 2 to 15, and then using the number, calculate its factorial (n!). Using do-while statement, make sure it only accepts a valid number (between 2 and 15) - if an invalid number is ent..

  Scanning and parsingimplement the lexical and syntactic

scanning and parsingimplement the lexical and syntactic analysis of minifun programming language. the scanner splits up

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