10. Databases
1. This question has 2 part(s).
1.1. Petr has set up a database for a science project on planets in the solar system. Part of the database is shown.
ID | Name_of_planet | Number_of_moons | Orbital_period | Rings | Gravity | Type_of_planet | First_observed |
|---|---|---|---|---|---|---|---|
4 | Mars | 2 | 1.88 | N | 0.38 | Regular | 1610 |
5 | Ceres | 0 | 4.61 | N | 0.27 | Dwarf | 1801 |
7 | Saturn | 62 | 29 | Y | 1.16 | Gas Giant | 1610 |
9 | Neptune | 14 | 165 | Y | 1.21 | Gas Giant | 1846 |
10 | Pluto | 5 | 248 | N | 0.62 | Dwarf | 1930 |
11 | Haumea | 1 | 309 | N | 0.401 | Dwarf | 2004 |
When Petr was designing his database, he had to set the data types for each field.
Complete the design table below by filling in the data types for each named field. Use the most appropriate data type.
Each data type must be different. For any numeric field, specify the type of number.
Field name | Data type |
|---|---|
Number_of_moons | |
Orbital_period | |
Rings | |
Name_of_planet |
1.2. Write down the names of the planets that are not gas giants but have at least one moon and were first observed after 1800.
Ai এর মাধ্যমে
১০ লক্ষ+ প্রশ্ন ডাটাবেজ
প্র্যাকটিস এর মাধ্যমে নিজেকে তৈরি করে ফেলো
উত্তর দিবে তোমার বই থেকে ও তোমার মত করে।
সারা দেশের শিক্ষার্থীদের মধ্যে নিজের অবস্থান যাচাই
No related questions found
