talisman

My Flutter code got the error message - No MediaQuery widget ancestor found. 

You responded back to do this - 

return MediaQuery(

    data: MediaQueryData(),

    child: MaterialApp(

    home: Scaffold(

    body: SizedBox(

    height: MediaQuery.of(context).size.height,

    child: const Dashboard(),

   ),

)

So where do I put this in my code listed below?

import 'package:flutter/material.dart';
void main() {runApp(const FoodList());}

class MyApp extends StatelessWidget {
const MyApp({super.key});

@override
Widget build(BuildContext context) {
return const MaterialApp(
home: FoodList(),
);
}
}



class FoodList extends StatelessWidget {
const FoodList({super.key});

@override
Widget build(BuildContext context) {
return Scaffold(
appBar: AppBar(
title: const Text("Food List"),
),
body: ListView(
children: const <Widget>[
ListTile(
title: Text("Food Item 1"),
trailing: Checkbox(value: false, onChanged: null),
),
ListTile(
title: Text("Food Item 2"),
trailing: Checkbox(value: false, onChanged: null),
),
ListTile(
title: Text("Food Item 3"),
trailing: Checkbox(value: false, onChanged: null),
),
ListTile(
title: Text("Food Item 4"),
trailing: Checkbox(value: false, onChanged: null),
),
ListTile(
title: Text("Food Item 5"),
trailing: Checkbox(value: false, onChanged: null),
),
ElevatedButton(
onPressed: null,
child: Text('Submit'),
)
],
),
);
}
}

What is binary tree?

This flutter code below - Got this error message - lib/info.dart(31,43): error G44692867: A value of type 'Color?' can't be assigned to a variable of type 'Color' because 'Color?' is nullable and 'Color' isn't. Using flutter version 3.3.6

import 'package:flutter/material.dart';
import 'package:flutter/services.dart';

import 'info.dart';

void main() => runApp(const MyApp());

class MyApp extends StatelessWidget {
const MyApp({super.key});

@override
Widget build(BuildContext context) {
SystemChrome.setPreferredOrientations([
DeviceOrientation.portraitUp,
]);
return MaterialApp(
debugShowCheckedModeBanner: false,
theme: ThemeData.light(),
home: const MyPage(),
);
}
}

class MyPage extends StatefulWidget {
const MyPage({super.key});

@override
State<MyPage> createState() => _MyPageState();
}

class _MyPageState extends State<MyPage> {
@override
Widget build(BuildContext context) {
return Scaffold(
appBar: AppBar(
title: const Text("Restaurant"),
),
body: Padding(
padding: const EdgeInsets.all(5),
child: ListView(
scrollDirection: Axis.vertical,
children: <Widget>[
Hero(
tag: "cakeitem",
child: FittedBox(
child: GestureDetector(
onTap: () {
Navigator.push(
context,
MaterialPageRoute(builder: (context) => InfoPage()),
);
},
child: Card(
// color: Colors.red,
shape: RoundedRectangleBorder(
borderRadius: BorderRadius.circular(15.0),
),
elevation: 5,
child: Row(
children: <Widget>[
itemcake(),
SizedBox(
width: 90,
height: 100,
child: ClipRRect(
borderRadius: BorderRadius.circular(15.0),
child: const Image(
fit: BoxFit.cover,
alignment: Alignment.topRight,
image: AssetImage('assets/cake.jpg'),
),
),
),
],
),
),
),
),
),
FittedBox(
child: Card(
// color: Colors.red,
shape: RoundedRectangleBorder(
borderRadius: BorderRadius.circular(15.0),
),
elevation: 5,
child: Row(
children: <Widget>[
juiceitem(),
Container(
width: 90,
height: 100,
child: ClipRRect(
borderRadius: BorderRadius.circular(15.0),
child: const Image(
fit: BoxFit.cover,
alignment: Alignment.topRight,
image: AssetImage('assets/juice.jpg'),
),
),
),
],
),
),
),
FittedBox(
child: Card(
// color: Colors.red,
shape: RoundedRectangleBorder(
borderRadius: BorderRadius.circular(15.0),
),
elevation: 5,
child: Row(
children: <Widget>[
pizzaitem(),
SizedBox(
width: 90,
height: 100,
child: ClipRRect(
borderRadius: BorderRadius.circular(15.0),
child: const Image(
fit: BoxFit.cover,
alignment: Alignment.topRight,
image: AssetImage('assets/pizza.jpg'),
),
),
),
],
),
),
),
FittedBox(
child: Card(
// color: Colors.red,
shape: RoundedRectangleBorder(
borderRadius: BorderRadius.circular(15.0),
),
elevation: 5,
child: Row(
children: <Widget>[
eliteitem(),
Container(
width: 90,
height: 100,
child: ClipRRect(
borderRadius: BorderRadius.circular(15.0),
child: const Image(
fit: BoxFit.cover,
alignment: Alignment.topRight,
image: AssetImage('assets/elite.jpg'),
),
),
),
],
),
),
),
],
),
),
);
}

Widget itemcake() {
return Column(
//mainAxisAlignment: MainAxisAlignment.start,
crossAxisAlignment: CrossAxisAlignment.center,
children: <Widget>[
const Padding(
padding: EdgeInsets.symmetric(horizontal: 5),
child: Text(
"Italian Choco Cake",
style: TextStyle(
fontWeight: FontWeight.bold, fontSize: 15, color: Colors.red),
),
),
const SizedBox(
height: 5,
),
const Text(
"Dark belgium chocolate",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 9.5,
color: Colors.grey),
),
const SizedBox(
height: 5,
),
Row(
children: <Widget>[
const Icon(
Icons.shopping_cart,
size: 15,
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.lightBlue[100],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Cold",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.red[100],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Fresh",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
],
),
const SizedBox(
height: 5,
),
Row(
mainAxisAlignment: MainAxisAlignment.start,
children: const <Widget>[
Text(
"Ratings",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 7,
color: Colors.grey),
),
SizedBox(
width: 10,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
],
),
],
);
}

Widget juiceitem() {
return Container(
//width: 150,
child: Column(
//mainAxisAlignment: MainAxisAlignment.start,
crossAxisAlignment: CrossAxisAlignment.center,
children: <Widget>[
const Padding(
padding: EdgeInsets.symmetric(horizontal: 5),
child: Text(
"Fresh Mango Juice",
style: TextStyle(
fontWeight: FontWeight.bold, fontSize: 15, color: Colors.red),
),
),
const SizedBox(
height: 5,
),
const Text(
"Dark belgium chocolate",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 9.5,
color: Colors.grey),
),
const SizedBox(
height: 5,
),
Row(
children: <Widget>[
const Icon(
Icons.shopping_cart,
size: 15,
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.lightBlue[100],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Cold",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.red[100],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Fresh",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.yellow[400],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"New",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
],
),
const SizedBox(
height: 5,
),
Row(
mainAxisAlignment: MainAxisAlignment.start,
children: const <Widget>[
Text(
"Ratings",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 7,
color: Colors.grey),
),
SizedBox(
width: 10,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
],
),
],
),
);
}

Widget pizzaitem() {
return Column(
//mainAxisAlignment: MainAxisAlignment.start,
crossAxisAlignment: CrossAxisAlignment.center,
children: <Widget>[
const Padding(
padding: EdgeInsets.symmetric(horizontal: 5),
child: Text(
"Cheese Pizza Italy ",
style: TextStyle(
fontWeight: FontWeight.bold, fontSize: 15, color: Colors.red),
),
),
const SizedBox(
height: 5,
),
const Text(
"Double cheese New York Style",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 9.5,
color: Colors.grey),
),
const SizedBox(
height: 5,
),
Row(
children: <Widget>[
const Icon(
Icons.shopping_cart,
size: 15,
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.deepOrange[300],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Spicy",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.yellow[400],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"New",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
],
),
const SizedBox(
height: 5,
),
Row(
mainAxisAlignment: MainAxisAlignment.start,
children: const <Widget>[
Text(
"Ratings",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 7,
color: Colors.grey),
),
SizedBox(
width: 10,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
],
),
],
);
}

Widget eliteitem() {
return Column(
//mainAxisAlignment: MainAxisAlignment.start,
crossAxisAlignment: CrossAxisAlignment.center,
children: <Widget>[
const Padding(
padding: EdgeInsets.symmetric(horizontal: 5),
child: Text(
"Alinea Chicago",
style: TextStyle(
fontWeight: FontWeight.bold, fontSize: 15, color: Colors.red),
),
),
const SizedBox(
height: 5,
),
const Text(
"Classical French cooking",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 9.5,
color: Colors.grey),
),
const SizedBox(
height: 5,
),
Row(
children: <Widget>[
const Icon(
Icons.shopping_cart,
size: 15,
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.deepOrange[300],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Spicy",
style: TextStyle(fontWeight: FontWeight.bold, fontSize: 9.5),
),
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.red,
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"Hot",
style: TextStyle(
fontWeight: FontWeight.bold,
fontSize: 9.5,
color: Colors.white),
),
),
const SizedBox(
width: 5,
),
Container(
width: 35,
decoration: BoxDecoration(
color: Colors.yellow[400],
//color: Theme.of(context).accentColor,
borderRadius: BorderRadius.circular(10),
),
alignment: Alignment.center,
child: const Text(
"New",
style: TextStyle(
fontWeight: FontWeight.bold,
fontSize: 9.5,
),
),
),
],
),
const SizedBox(
height: 5,
),
Row(
mainAxisAlignment: MainAxisAlignment.start,
children: const <Widget>[
Text(
"Ratings",
style: TextStyle(
fontWeight: FontWeight.normal,
fontSize: 7,
color: Colors.grey),
),
SizedBox(
width: 10,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
Icon(
Icons.star,
size: 10,
color: Colors.orangeAccent,
),
],
),
],
);
}
}

JAVA GUI FOR A MYSQL DATABASE. Selecting 3 tables from your database to implement the gui for. The tables must meet the following criteria. 1. At least one table must have one or more foreign key relationships 2. A second table must be part of the relationship of the first 3. The last table can be any table you want GUI Implementation For each database table, a JFrame must be created with all the necessary input for each table attribute on the screen, except the primary keys, which should be non-editable on the UI.

Each screen will provide the ability to insert, delete, or update the selected database row from the database

HERE IS MY DATABASE ITS ABOUT A BOOKSTORE create table address(street_address varchar(),area_number int(),city varchar(),state varchar(),pincode int());

create table BOOK(book_name varchar(),book_description varchar(100),book_genre varchar());

create table Transaction(transaction_id int(),book_name varchar(),customer_address varchar());

create table Publisher(name int(),location varchar(),street_address varchar(),area_number int(),city() varchar(),state varchar(),publisher_id());

create table customer_name(first_name varchar(),middle_name varchar(),last_line varchar());

create table customer_address(stree_address varchar(),area_number int(),city varchar(),state varchar(),zip_code int());

create table genre(genre_name varchar(),genre_id int());

insert into table_name(table fields)

E.g;

insert into author(T,Rama,Rao);

Syntax to create triggers

create trigger [trigger_name]

[before | after]

{insert | update | delete}

on [table_name]

[for each row]

[trigger_body]

CREATE FUNCTION [schema_name.]function_name

( [ @parameter [ AS ] [type_schema_name.] datatype

[ = default ] [ READONLY ]

, @parameter [ AS ] [type_schema_name.] datatype

[ = default ] [ READONLY ] ]

)

RETURNS return_datatype

[ WITH { ENCRYPTION

| SCHEMABINDING

| RETURNS NULL ON NULL INPUT

| CALLED ON NULL INPUT

| EXECUTE AS Clause ]

[ AS ]

BEGIN

[declaration_section]

executable_section

RETURN return_value

END;

CREATE VIEW view_name AS

SELECT column1, column2, ...

FROM table_name

WHERE condition;

Stored Procedure Syntax

CREATE PROCEDURE procedure_name

AS

sql_statement

GO;

Execute a Stored Procedure

EXEC procedure_name;

I have been trying but i am blank on this?

Answer all the questions

PL/SQL language

STATEMENTS :
A Bank is characterized by:
• Bank code: character on 10 positions,
• Company name: character on 10 positions
• Capital: Numeric with 3 positions after the comma,
• Address: character on 10 positions.
It has a set of Agencies. Each Agency is characterized by:
• Agency code: character in 10 positions,
• Label: character in 10 positions,
• Address: character on 10 positions,
• Latitude: character on 10 positions,
• Longitude: character in 10 positions.
An Agency has several clients. A Client is characterized by:
• Customer code: character on 10 positions,
• Name: character in 30 positions,
• Address: character in 30 positions,
• Telephone: character on 10 positions
A Client may have 1 or more Accounts. An Account is characterized by:
• Account number: character on 10 positions,
• Balance: Numerical with 3 positions after the comma,
• Flow rate threshold: Numeric with 3 positions after the decimal point,
• Balance date: Date.

• State: character on 10 positions.

There are two types of Account
• Current account
• Savings account.
An Account can have one or more Cards attached to it. A Card is characterized by:
• Card number: character on 16 positions
• Type of card: character on 10 positions
• Ceiling: Numerical with 3 positions after the decimal point
• Expiration date: Date

QUESTIONS :
1. Give the class diagram.
2. Give the different tables indicating the relationships between the different Tables.
3. Write a Withdraw function in PL/SQL that takes an account number as an argument and a withdrawal amount then performs the withdrawal operation by modifying the balance in the Account table. Note the withdrawal can only be made if balance – amount > threshold. The function returns the new balance after the withdrawal.
4. Write a Payment function in PL/SQL that takes as argument a number of the account and an amount then updates the balance in the Account table. The function returns the new balance after withdrawal.
5. Write a trigger to raise an exception in the event of a decrease in the balance of an account whose status is “blocked”.
6. To archive the history of Account table update operations, create a History table (NumCpt, operation_date, operation_type). Write a trigger allowing, after the execution of each operation on Account, to add a tuple regarding this operation to the History table.
7. Write a Withdrawal_Card function in PL/SQL which takes as argument a card number card and an amount then updates the balance in the Account table. Function returns the new balance after the withdrawal. The withdrawal can only be made if the balance allows him and the ceiling.
8. Write a trigger allowing to raise an exception in the case of an expiration of the date of a card.
9. Write a procedure that allows each Bank to display the branch code, wording of the Agency, name and balance of the Client having the largest balance in this Agency.
10. Write a PL/SQL procedure to display for all Agencies the three first highest Account balances, if there is not only one balance then display for the second and third, the same value as the first; and if he only two different balances exist, so display the same value for the third than the second.

The speech is for process assignment draft outline the first image are the requirements to add and edit the speech.

I’m gonna put down here the speech that needs to be editing and added for:

The United States has always been a nation of explorers. From the early days of the Lewis and Clark expedition to the recent Mars rover landing, American astronauts have been at the forefront of space exploration. On July 20, 1969, American astronauts Neil Armstrong and Edwin "Buzz" Aldrin became the first humans to walk on the moon.

The Apollo 11 mission was a crowning achievement for the United States and for the world of space exploration. But it was also a very personal achievement for the two men who made that historic first step. In this speech, I'll be telling the story of the Apollo 11 mission from the perspective of Neil Armstrong and Buzz Aldrin. I'll be sharing what motivated them to become astronauts, what it was like to train for the mission, and what it felt like to take that first step onto the moon.

I hope that by sharing this story, I can give you a better understanding of the courage and determination of the men who made history on that fateful day.

1. On July 20, 1969, American astronauts Neil Armstrong and Edwin "Buzz" Aldrin became the first humans to walk on the moon.

2. The Apollo 11 mission was a crowning achievement for the United States and for the world of space exploration.

3. But it was also a very personal achievement for the two men who made that historic first step.

4. In this speech, I'll be telling the story of the Apollo 11 mission from the perspective of Neil Armstrong and Buzz Aldrin.

5. I'll be sharing what motivated them to become astronauts, what it was like to train for the mission, and what it felt like to take that first step onto the moon.

Explanation:

1. America's race to the moon was a competition to see who could be the first to land a human on the moon.

2. John F. Kennedy was the president at the time and he was a big proponent of the space program.

3. The Soviet Union was the main competitor in the race to the moon.

4. The United States eventually won the race to the moon.

section 1;

1. America's space program was started in response to the Soviet Union's space program.

2. The Soviet Union's space program was started in

response to the United States' space program. 3. The two space programs were in a race to see who could be the first to land a human on the moon.

section 2:

1. The United States eventually won the race to the moon.

2. The United States was the first to land a human

on the moon.

3. The United States has since been the dominant power in space.

section 3;

1. The space race was a competition between the United States and the Soviet Union.

2. The United States won the race to the moon. 3. The space race was a big part of the Cold War.

conclusion;

1. The space race was a competition between the United States and the Soviet Union.

2. The United States won the race to the moon. 3. The space race was a big part of the Cold War.

In 1961, John F. Kennedy gave a speech to a Joint Session of Congress in which he proposed the United States' goal of landing a man on the moon within the decade. This speech came at a time when the United States was behind the Soviet Union in the Space Race, and it served as a rallying cry for the American people to support the effort to catch up.

The first section of the speech outlines the reasons why Kennedy believes that it is important for the United States to be the first nation to land a man on the moon. He argues that this feat would demonstrate American superiority in the fields of science and technology, and that it would be a symbol of American progress and determination.

The second section of the speech describes the steps that Kennedy believes the United States must take in order to achieve this goal. He calls for increased funding for the space program, and for the establishment of a new government agency to oversee the effort.

The third section of the speech is a call to action for the American people. Kennedy asks for their support in achieving this goal, and he assures them that the United States will succeed.

conclusion; In conclusion, John F. Kennedy's speech was a rallying cry for the American people to support the effort to land a man on the moon within the decade. The speech outlined the reasons why Kennedy believed this was important, and it described the steps that he believed the United States must take in order to achieve this goal. The speech was a call to action for the American people, and it served as a symbol of American progress and determination.