The model above needs some improvement. Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?. TRANSACTIONPAYMENT STATUSPayment_Statusid: INTEGERPaymentid: INTEGER (FK)Userld: INTEGER (FK)PAYMENTPaymentid INTEGERUserld INTEGER (FK)Transactionld: INTEGERUserld: INTEGER (FK)Description: VARCHAR(100)Cancelation: BOOLEANConformation_number. INTEGERSuccess_urt: VARCHAR(100)Cancel_urt: VARCHAR(100)Price_usd. INTEGERDate: DATEAmount INTEGERBlockchain_url: VARCHAR(100)Confirms: INTEGERDate: DATENetwork fee: INTEGERDescription: VARCHAR(100)Status: VARCHAR(100)JUSERUserld: INTEGERName: VARCHAR(100)Email: VARCHAR(100)Surname: VARCHAR(100)Password: VARCHAR(100)Phone_number. VARCHAR(100)ACCOUNTAccountid: INTEGERUserld: INTEGER (FK)POOLPoolld: INTEUserid: INTEBalance: INTEGERAmount INTEReward timeNumber ofStart_date: DEnd_date: DAPenalties: INType: VARCILOGINLoginid: INTEGERUserld: INTEGER (FK)WALLETWalletld: INTEGERUserld: INTEGER (FK)Email: VARCHAR(100)Password: VARCHAR(100)3x_Staking: INTEGER1x_Staking INTEGERPubkey_adress: VARCHAR(100)Wallet adress: VARCHAR(100)

Normalization Rules Normalization rules for entity-relationship diagrams are based on (and are…

Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?.

Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?.

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter4: The Selection Structure

Section: Chapter Questions

Problem 11E

See similar textbooks

Related questions

Q: Instructions Write a C++ code based on the Sample Dialog Validate input. Offer to "Try Again". Uploa...

A: Step-1: StartStep-2: Declare a char variable ch and assign with yStep-3: Print message "------------...

Q: 1. Take ASCII values as input & print corresponding Character. Suppose, input 97 and output a Using ...

A: n=int(input("enter ascii value: "))a=chr(n)print(a)

Q: vi. Explain the distinction between authorization and authentication in web testing.

A: Introduction: Authorization: Authorization is the process of allowing an authenticated user to acces...

Q: You have many filesystems on your hard drive, each of which is mounted to a different directory in t...

A: Introduction: You have many filesystems on your hard drive, each of which is mounted to a different ...

Q: I need a DLL component that has several types of functions to read an Excel file. The main function ...

A: Exporting Data Table to Excel worksheets can be achieved through the import data method. The followi...

Q: Create a flowchart of the following problem: The manager of a football stadium wants you to ...

A: Start Initialise variables "PremiumCost" as 250, "BoxCost" as 100, "SidelineCost" as 50 and "General...

Q: Discuss some factors that have helped the growth of the World Wide Web.

A: factors that have helped the growth of the World Wide Web.

Q: What is the procedure for locating a certain unit of data in a memory?

A: Introduction: Each bit of binary data is like stored on a semiconductor memory chip in a small circu...

Q: a. Write a python program that writes data to a file. The data consists of a series of records, each...

A: a) Create a file say 'file1.txt' to which program writes data. Python program that writes data to fi...

Q: Write a C++ program to generate a random vehicle registration number that is a string of length 10 a...

A: Introduction: Here we are required to write a C++ program that creates a random Vehicle Registration...

Q: c) Connect the forms to the database and demonstrate how the forms can be used to view, update and d...

A: Database SQL commands are instructions. It is used to communicate with the database. It is also used...

Q: Write a program in C-language that will accept any positive number and will count up, starting from ...

A: Introduction: Looping reduces the difficulty of complicated tasks or problems to a manageable level....

Q: Solve the problem in C++ (Financial application: compute the future investment value) Write a func...

A: #include <iostream>#include <math.h>using namespace std; double futureInvestmentValue(do...

Q: Describe the components of a disaster recovery plan. What is the difference between backup plans for...

A: Introduction: Each information system is designed with backup devices to ensure that data and inform...

Q: Data Structures and Algorithms is a course that teaches students about data structures and algorithm...

A: Introduction Stack is a dat structure which follows LIFO (Last In First Out) principle where the el...

Q: 1. create an input box to filter the table by name (for example, typing in “Billy” would filter out ...

A: <!DOCTYPE html><html><title>Filter a HTML List by names</title><body> ...

Q: A certain college classifies students according to credits earned. A student with less than 7 credit...

A: the code is an given below

Q: Discuss intents and how they may be used in Android programming. Make a point of mentioning the two ...

A: Intents and their purpose in Android Application: An intent is an object that performs certain task...

Q: --Problem -3 -Create a flowchart design that depicts the solving of the following problem: Asks user...

A: Please refer to the following step for the complete solution of the problem above.

Q: Write a script that inputs a line of plaintext and a distance value and outputs an encrypted text us...

A: message = input("Enter a message: ") distance = int(input("Enter the distance value: ")) result = ''...

Q: Consider the following relations about NBA: P LAY ER(pid, pname, nation). Each tuple describes a p...

A: 1 Select t.tname,r.year from TEAM t join REGISTER r on t.tid = r.tid join PLAYER on p.pid= r.pid...

Q: Computer Networking: A Top-Down Approach 8th Edition For TCP connection, five measured ?ampleRTT v...

Q: Question No. 1: Briefly explain the usage of following UNIX commands, also include the screen shot o...

A: date command is utilized to show the framework date and time. date order is likewise used to set dat...

Q: In terms of temporal complexity, distinguish between Hash Tables and graphs. as well as the advan...

A: Intro Hash Table is a data structure that stores data in an associative manner. In a hash table, dat...

Q: Create a program that contains a function pairs(x) where x is a list of integers. The function shoul...

A: Program to print the list which has pair: Note: Since you didn't mention any programming language, I...

Q: They are used to address the problems O principles O patterns O state O relation

A: Correct Option is Principles

Q: What are the canonical and standard forms of Boolean function?

A: The Answer is

Q: Q20-Following Grammar is give (I am using or instead of usual | to avoid confusion) a) Find the Firs...

A: Answers: We have to provide the detailed solution in the below Picture:

Q: List the advantages and disadvantages of using the cloud for storage and other services.

A: Introduction of Cloud Storage: Cloud storage is a service model in which data is stored on the remot...

Q: Name a dynamic scoping scripting language in computer science.

A: Introduction: Name a dynamic scoping scripting language in computer science.

Q: What are your thoughts on cyberbullying?

A: Introduction: Bullying online can be far more emotionally draining than bullying in person.

Q: Justify the requirement for a trained project manager to oversee complicated tasks.

A: What is Project Manager is an given below :Project Manager is an expert who is responsible for all ...

Q: What was the motivation behind the development of computer programming languages?

A: Introduction: Language for showing a precise set of digital computer commands, such as computer prog...

Q: Q: Write a program in Q and print the the numbe matrix (as shown below of the first three numhe

A: given - Q: Write a program in Qbasic language to readand print the the numbers of the one dimensiona...

Q: illustrate the execution of the in-place heap sort algorithm in the following input sequence: {2, 5,...

Q: What exactly is a flowchart? Create a flowchart to print the factorial of the numbers 1 through n.

A: Flowchart:- A flow chart portrays an algorithm, a method, or a process. In many countries, they are ...

Q: Write a program in C-language that will accept any positive number and will count down to 1, startin...

A: #include <stdio.h> int main(){ unsigned int n; unsigned int i; printf("Input a number...

Q: When making hardware selections, what three variables are considered?

A: Introduction: Hardware is the actual component or equipment of a system that carries out the actions...

Q: Does CDN performance vary, even with the same CDN? Explain your response with examples.

A: First of all, Let's first know about CDN A content delivery network (CDN) is a worldwide network of ...

Q: web app

A: given - make a barcode reader web application to scan barcode using a Asp.net or C#

Q: Q9. i. What are the different forms of Web testing security issues? ii. What are some of the most...

A: Introduction: i. Some Web testing security problem types are listed under: DOS(Denial of Service...

Q: Some firms ban their employees from bringing USB flash memory devices to work in order to prevent un...

A: "Data" means a representation of information, knowledge, facts, concepts or instructions which are b...

Q: Define a star schema briefly and explain how it is utilised in data design for BI systems. Explain h...

A: STAR SCHEMA - Star schema is a kind of the mature modeling way or the approach that is widely adopt...

Q: Explain your personal understanding of In-House Development in your own words.

A: Introduction: a collection of similar-looking individual residences or apartment houses that are typ...

Q: What is the purpose of the identifying value? What will happen if there is no identification number ...

A: Identification Value: It is the unique value given to every packet during transmission. During Tra...

Q: In terms of machine learning or deep learning algorithms, how has artificial intelligence (AI) evolv...

A: Introduction: The last decade witnessed the phenomenal rise of Artificial Intelligence. The impact o...

Q: QUESTION 10 is a solution to the problem of memorizing information and maintaining records as well a...

A: New media has some of the features, which are Accessibility, Audience, Interactivity and Convergence...

Q: Who is in charge of the post-implementation review? When should it be done? Would a post-implementat...

A: Intro Who is in charge of the post-implementation review? When should it be done? Would a post-imple...

Q: Answer how we could reduce Common Subsequence to Edit Distance in poly time?

A: Explanation The long common subsequence and edit distance are usually in the middle of the most imp...

Q: DATABSE

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as ...

Concept explainers

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.

Question

The model above needs some improvement. Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?.

TRANSACTION
PAYMENT STATUS
Payment_Statusid: INTEGER
Paymentid: INTEGER (FK)
Userld: INTEGER (FK)
PAYMENT
Paymentid INTEGER
Userld INTEGER (FK)
Transactionld: INTEGER
Userld: INTEGER (FK)
Description: VARCHAR(100)
Cancelation: BOOLEAN
Conformation_number. INTEGER
Success_urt: VARCHAR(100)
Cancel_urt: VARCHAR(100)
Price_usd. INTEGER
Date: DATE
Amount INTEGER
Blockchain_url: VARCHAR(100)
Confirms: INTEGER
Date: DATE
Network fee: INTEGER
Description: VARCHAR(100)
Status: VARCHAR(100)
JUSER
Userld: INTEGER
Name: VARCHAR(100)
Email: VARCHAR(100)
Surname: VARCHAR(100)
Password: VARCHAR(100)
Phone_number. VARCHAR(100)
ACCOUNT
Accountid: INTEGER
Userld: INTEGER (FK)
POOL
Poolld: INTE
Userid: INTE
Balance: INTEGER
Amount INTE
Reward time
Number of
Start_date: D
End_date: DA
Penalties: IN
Type: VARCI
LOGIN
Loginid: INTEGER
Userld: INTEGER (FK)
WALLET
Walletld: INTEGER
Userld: INTEGER (FK)
Email: VARCHAR(100)
Password: VARCHAR(100)
3x_Staking: INTEGER
1x_Staking INTEGER
Pubkey_adress: VARCHAR(100)
Wallet adress: VARCHAR(100)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

You have a storage account that contains multiple containers, blobs, queues, and tables.You need to create a key to allow an application to access only data from a given table in the storage account.Which authentication method should you use for the application? 1 SAS shared service SAS user delegation SAS
The primary keys are identified below. The following data types are defined in the SQL Server. tblLevels Level – Identity PKClassName – text 20 – nulls are not allowed tblPoolPool – Identity PKPoolName – text 20 – nulls are not allowedLocation – text 30 tblStaffStaffID – Identity PKFirstName – text 20MiddleInitial – text 3LastName – text 30Suffix – text 3Salaried – BitPayAmount – money tblClassesLessonIndex – Identity PKLevel – Integer FKSectionID – IntegerSemester – TinyIntDays – text 20Time – datetime (formatted for time)Pool – Integer FKInstructor – Integer FKLimit – TinyIntEnrolled – TinyIntPrice – money tblEnrollmentLessonIndex – Integer FKSID – Integer FK (LessonIndex and SID) Primary KeyStatus – text 30Charged – bitAmountPaid – moneyDateEnrolled – datetime tblStudentsSID – Identity PKFirstName – text 20MiddleInitial – text 3LastName – text 30Suffix – text 3Birthday – datetimeLocalStreet – text 30LocalCity – text 20LocalPostalCode – text 6LocalPhone – text 10 Implement this…
Create a menu-driven application to keep track of a list of subscribers to a newsletter.The application should allow the user to add a new subscriber, remove a current subscriber, update a subscriber’s data, and display the current list of subscribers. Each subscriber should be identified by a unique ID assigned by the system.For each subscriber, you need to store first name, last name, and email address.The application must have:• A linked list as the main data structure in the application. You must use the C++ Standard Template Library (STL).• A “subscriber” class that contains data and methods related to each subscriber.
Design an Android application for the Department of Tourism called SATourismApp. The application must have a GUI. The application must make use of the SQLite Database to store and retrieve details of the tourist attractions. The app must consist of the following activities/classes: Main activity: This is the main user interface of the application. PlaceDetails class: This will handle the details of the tourist attractions. SQLite Helper class: This will handle the database and tables creation and also performing the CRUD operations. SQLite Helper class For this task you are only going to perform CR (Create & Read) operations. Create an SQLite database called satourist. Your database should have a table called touristattractions to store details of the tourist destinations found in the nine provinces of South Africa. provides the provinces and the tourist attractions you need to add to your database. Make use of an addPlaces() method to add the tourist attractions…
Will be using code Lginter! Registration First Name Last Name Email Address Password Confirm Password Require to have validation of user input Valid email address Make sure the email address does not exist in the database before doing insert into the database Password and Confirm Password are matching Password need to hash before doing insert into database ("password_hash" is a PHP build in function which can be used)
Type the following command and press Enter, to add a user to the system. Type msfadmin forthe password.mfadmin@metasploitable:~$ sudo useradd superUSERADD COMMAND9. Type the following command to verify that the user exists and determine their UID. Thenpress Enter.mfadmin@metasploitable:~$ id superID COMMAND10. Get the information for below Challenge Flag by using the same techniques from the previous steps.
Create a session variable called SProot and assign the generated positive root value to it in Oroots.php. Display this session variable in PosRoot,php page.
You have a GitHub workflow that deploys an Azure web app. The workflow is configured to trigger a deployment following a pull request that includes a label. You plan to configure the pull request of the workflow to trigger the deployment only if the label is set to a string of "stage". The workflow includes the following section. if: contains(<missing element>.event.pull_request.labels.*.name, 'stage') What should you add for the missing element of the workflow?
{ String str = tf5.getInt("ID"); Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:sqlserver://NOMBUSO1806:1433;databaseName= Employee ATM", "NOMBUSO1806", "mysql1234"); // write your database username and password PreparedStatement st = con.prepareStatement("select * from Employees where ID=?"); // Search with ATM ID st.setString(1, str); ResultSet rs = st.executeQuery(); // Excuting Query if (rs.next()) { String s = rs.getString(1); String s1 = rs.getString(2); String s2 = rs.getString(3); // Sets Records in TextFields. tf1.setText(s); tf2.setText(s1); tf3.setText(s2); my getInt() is throwing an error that the method is not found. what should i do?
Use an API – Application Programming Interface – to retrieve data from via the Internet based on the user’s input. Your program should tell the user what category their selection was (movie, book, etc.) Code should please begin as shown below import urllib.request import urllibimport jsondef get_data(item): payload={'q':item}item=urllib.parse.urlencode(payload)api_url = "https://tastedive.com/api/similar?" + item page=urllib.request.Request(api_url,headers={'User-Agent': 'Mozilla/5.0'}) infile=urllib.request.urlopen(page).read()decoded = infile.decode('utf8')the_dictionary = json.loads(decoded) return the_dictionary
You are required to write a Product Management Android application for a small business as described below. The user of the application is the Purchase Manager. The Purchase Manager requires functionality for decision support on making purchases and updating stock quantities when stocks are received. Viewing of updated stock quantities and stock prices is required. Using Andriod programming Create View 1 as follows: This view is the “Receiving Stocks” view. It must show a list of Product Names, a field for entering the quantity received, and a button, “Update Stocks”. The Purchase Manager will select the relevant Product Name, enter an integer, and click on the button. The button should add the quantity entered above to the StockOnHand field for the specified Product Name, as well as, subtract the quantity entered from the StockInTransit field. The “Output View” must then be updated. See below. Create View 2 as follows: This view is the “Ordering Stocks” view. It shows a list of…
Write a Window application in C# that read employee recordfrom Microsoft access database using odbc (Open DatabaseConnectivity). Your application wouldretrieve the employeerecords i.e. Employee id, name, address and ageand display this record using textbox control.Note:Don’t send me the wholeapplication. You just send me the code displaying how youconnect with Microsoft access database and afterthat you reademployee records from employee table.